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

pentaho kettle
chris polzer picture chris polzer · Feb 27, 2013 · Viewed 49.6k times · Source

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 any help.

Answer

DWBI Developer picture DWBI Developer · May 3, 2013

We can use the below steps to generate Dynamic column generation:

  1. calculator
  2. add constants.
  3. Select required fields in table input and assign those values as a set variable and second transformtion level use get variables hop

Related questions

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
Pentaho Kettle: how to pass variable from transformation to another transformation inside job

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 …

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