Adil
Adil

Reputation: 11

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

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

Upvotes: 0

Views: 969

Answers (1)

AlainD
AlainD

Reputation: 6356

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.

Like this:

Upvotes: 2

Related Questions