I want to create transformation in which I want to add multiple inputs table column value into one table in the same column in pentaho

Question

I want to create transformation in which I want to add multiple inputs table column value into one table in the same column in pentaho e.g Two input products table having id and name and one output table with id and column wants to add all values of both in output table

Table one Table two I want to in one table and the same column

Show sample data and desired results. – underscore_d Jan 08 '18 at 11:44 — underscore_d, Jan 08 '18 at 11:44

score 2 · Answer 1 · answered Jan 08 '18 at 13:06

Just draw arrows from the table one and two to the same process step.

Ah, yes, PDI will tell you the input flow must have the same metadata, meaning the columns must be in the same order, with the same name and the same type. So, in your case you'll need to rename the columns with a Select Value.

:

I want to create transformation in which I want to add multiple inputs table column value into one table in the same column in pentaho

1 Answers1