Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

pentaho

pdi

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.
like image 359
syed tabrez Avatar asked Oct 28 '25 09:10

syed tabrez


1 Answers

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

like image 82
Yuval Herziger Avatar answered Oct 31 '25 10:10

Yuval Herziger



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!