[Tips] Pentaho - How to Add a New Column to the Stream?

 

Scenario

It is common to add a timestamp field to a table so that timestamp of a record update can be recorded. In Spoon, system date can be obtained by [Get system info] step which produces one column and one value. 

To merge it into the stream with multiply rows and columns, [Join rows (cartesian product)] step can be used.

Example

Preview [Generate rows] :

 Preview [Get system info] :

Output: (Preview [Join rows (cartesian product)])