Pentaho Kettle: how to pass variable from transformation to another transformation inside job

pentaho kettle spoon
Volder picture Volder · May 22, 2015 · Viewed 22k times · Source

I have two transformations in the job. In the first trasnformation - I get details about the file.

Now I would like to pass this information to the second transformation, I have set variable in the settings parameters of the trasnformation #2 and use Get Variables inside - but the values are not passed.

See attached sample: https://www.hightail.com/download/bXBiV28wMVhLVlZWeHNUQw

LOG_1 - displays file time, however LOG_2 and LOG_3 are not producing any value.

How can I pass variable across transformations and to parent job.

Answer

Rishu Shrivastava picture Rishu Shrivastava · May 23, 2015
  1. Try checking the box in the second transformation as below image:

enter image description here

  1. Remove all the logs from the Job file you shared.

You may try reading this blog.

Hope this will resolve your issue :)

Related questions

Pentaho: How to dynamically add Field (= Column) to OutputRow?

I would like to dynamically add fields (or a new columns) to the resulting output row in Kettle. After spending hours reading through froum posts and he not so well done scripting documentation, I wondered if Stackoverflow would be of …

Read More
Use JSON Input step to process uneven data

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"AddressId":"1_102","Street":"One more street", "Locality":"Buenos Aires"}, {"AddressId":"1_102","Locality":"New York"} ]} However this seems not to be possible: Json …

Read More
Changing a field from String to Int in Pentaho Data Integration

I am taking JSON information from our online API and producing it in a table with DI. I have 4 fields url, deviceId, displacement & timestamp. These are all recorded as Strings but I want them to be Int values, bar …

Read More