Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Suggestion or example

  1. #1
    Join Date
    May 2006
    Posts
    167

    Default Suggestion or example

    Hi,
    I have to create a job to retrieve a list of 1300 items and for each item get its features from a table and do some update.
    So far I have never done such a job (for each X do ...).
    Is there an example you could point me to, please? Skimming in examples I haven't found.

    Thank you,
    Nicola

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    It all depends on what you exactly want ...

    E.g. You could:
    - make a transformation that creates the 1300 rows and passes to the result
    - make a transformation that process 1 row from the result.
    - Make a job that connects both using "execute for each row" on the second transformation.

    You could also:
    - Make 1 tramsformation that creates the 1300 rows and works with the those rows inside the same transformation. E.g. table input has an option that it will execute an SQL statement per incoming row (although the output would still appear on 1 output).

    ...

    Regards,
    Sven

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Hi Nico,

    It takes longer to explain it then it is to do it actually...

    Basically you create a job A.

    The first job entry is a transformation. In there you grab the 1300 rows and send them to the "Copy rows to result" step. (Job category)

    In the second job entry runs a job B. You need to select the option "Execute for every input row". In B you can use the result row again in a transformation (get rows from result) or set variables first.

    In the samples you will find:

    • samples/jobs/shell for every row
    • samples/jobs/run_all
    • process all tables

    HTH,
    Matt

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.