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

Question

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 1

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