Get rows from result step and Get Varaibles usage in Pentaho data Integeration

9.1k views Asked by At

can any one provide example for both get variables and get rows from result step in pentaho data integration.

  1. I have a job with two transformations.
  2. First transformation take sample input and genrate sample output and a the end i have copy rows to result step.
  3. My 2nd transformation has get rows from result step and a dummy.
  4. When I run my job i am not gettion output in the dummy.
  5. I even tried with the Get Variables Step instead of Get rows from result step even though i am not getting the output.
  6. so,how can i solve this.
2

There are 2 answers

0
Robin Wang On

maybe you should uncheck "copy previous result to parameter", this make the result(output by the previous trans) disapear ( anyway ,can't be get by "get rows from result" )

0
Yuval Herziger On

So, to make the answer as graphic and abstract as possible, let's assume we have a main job, and two transformations inside it (they could also be two sub-jobs).

Job:

Main job

Read Process Parameters would end like this:

Copy rows to results

Do something nice would have the following settings:

Under Advanced tab, 'Copy previous results to parameters?' check-box would be checked; If you wished the transformation to execute for each row, you would check the 'Execute for every input row?' check-box ; Parameters