Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Convert Single Column file into row

  1. #1

    Default Convert Single Column file into row

    I have file with one column and 10000 rows

    i need to convert into rows of 200 each separated by ,

    for example:

    Field 1

    1
    2
    3
    4
    5
    6
    7
    ....
    10000

    Convert to :

    Field 1:
    1,2,3,4....200
    201,202,203,.....400
    401,402,.....600


    Any suggestions or help?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Enjoy
    Attached Files Attached Files
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.