syed tabrez
syed tabrez

Reputation: 59

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

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.

Upvotes: 4

Views: 9643

Answers (2)

Robin Wang
Robin Wang

Reputation: 1

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" )

Upvotes: 0

Yuval Herziger
Yuval Herziger

Reputation: 1155

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

Upvotes: 4

Related Questions