Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Generate N rows for each record

  1. #1
    Join Date
    May 2006
    Posts
    167

    Default Generate N rows for each record

    Hi,
    I need to generate 20 rows for each table1 (retrieve from a table with 200 records).
    From table1 I use the code field (ex. AAA) and I generate AAA1 ....AAA20 records.
    The total is 20*200=4000 records.

    I usually implemented a job with 2 transformations and using "repeat for each record" option.

    I wonder if it's a best practice or there's another way (maybe inside a single transformation only).

    Thank you,
    Nic

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

    Default

    See a Clone Row step at work - category Utility.
    Replace the Grid with your Table Input and remove the steps with names in parentheses.
    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.