Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: How to create multiple rows from one input row

  1. #1

    Default How to create multiple rows from one input row

    for instance, the below input data

    account_number, dob,ssn, name1, name2,name3,name4

    200, 12/01/1988, 999999999, mike, Michael, john, Johnson


    how can I create 4 rows of the data below in kettle

    200, 12/01/1988, 99999999, mike
    200,12/01/1988,99999999,michael
    200,12/01/1988,999999999,john
    200,12/01/1988,999999999,Johnson

    thanks for your help.

  2. #2
    Join Date
    Dec 2009
    Posts
    332

    Default

    This is what you would use:
    http://wiki.pentaho.com/display/EAI/Split+field+to+rows

    Does that explain the method or do you need more information?

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

    Default

    Row-Normaliser is what I would use.
    The sample data make me cringe, though.

    Name:  RD.png
Views: 243
Size:  25.6 KB
    Last edited by marabu; 11-20-2015 at 01:57 PM. Reason: typo, image
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Dec 2009
    Posts
    332

    Default

    Well, if it is simple you want - try the attached
    Attached Files Attached Files

  5. #5
    Join Date
    Jun 2010
    Posts
    114

    Default

    Quote Originally Posted by jdsignature View Post
    for instance, the below input data

    account_number, dob,ssn, name1, name2,name3,name4

    200, 12/01/1988, 999999999, mike, Michael, john, Johnson


    how can I create 4 rows of the data below in kettle

    200, 12/01/1988, 99999999, mike
    200,12/01/1988,99999999,michael
    200,12/01/1988,999999999,john
    200,12/01/1988,999999999,Johnson

    thanks for your help.
    Please use pentaho row normalizer to get the desired output
    Attached Images Attached Images  
    Thanks,
    Om
    ----------------------
    Spoon version -4.4.0

  6. #6

    Default

    Thanks for your replies.
    Sorry I provided the wrong data:
    account, dob, ssn, Company1, state1, company2, state2, compay3, state3
    200,12/01/1988,999999999, ibm, PA, MACY,GA,ABC,ma


    I expected the output as:

    200,12/01/1988,999999999,ibm,pa
    200,12/01/1988,999999999,macy,ga
    200,12/01/1988,99999999,abc,ma

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

    Default

    Makes much more sense now


    Name:  RN.png
Views: 231
Size:  30.4 KB
    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.