Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

pentaho

kettle

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.

like image 694
chris polzer Avatar asked Feb 27 '13 14:02

chris polzer


1 Answers

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
like image 84
DWBI Developer Avatar answered Sep 17 '22 18:09

DWBI Developer