CODEWITHSUNDEEP
mergestreamappendtransformationpentaho
ValQc
ValQc

Reputation: 77

How can I merge two streams with identical columns in Pentaho?

I am new user in Pentaho and maybe my question is very simple. I have two streams with identical columns, e.g. stream S1 has the columns: A, B, C, and stream S2 has columns: A, B, C (same name, same order, same data type). I want to merge or append these two streams into a single stream containing the columns A, B, C. However, when I use merge join (with the option FUL OUTER JOIN) my result is a stream with the columns: A, B, C, A_1, B_1, C_1. It is not what I want. I tried to use the append stream step, but in this case appeared nothing in the preview.

Upvotes: 2

Views: 6908

Answers (1)

Andolasoft Inc
Andolasoft Inc

Reputation: 1296

As per your requirement first create two stream.

Here we have taken two streams i.e. "stream1.xls" and "stream2.xls".

Then built the transformation using the "Sorted merge" join

For better understanding please refer the screenshots.

enter image description here

enter image description here

Upvotes: 6

Related Questions