How can I merge two streams with identical columns in Pentaho?
ValQc
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.
AndolaSoft Inc
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.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
How can I merge columns in Pentaho?
- 2
How do I merge two tables in Excel that have identical columns?
- 3
How can I merge two files in Pentaho Data Integration (Kettle)
- 4
How can I merge two files in Pentaho Data Integration (Kettle)
- 5
How can I merge two datasets that have identical column names
- 6
How can I merge together two co-occurrence matrices with overlapping but not identical vocabularies?
- 7
How can I merge (concatenate) two columns in an array/matrix?
- 8
How can I merge some columns of two files using perl?
- 9
How to merge two streams in Java?
- 10
How can I check if two Java classes are semantically identical?
- 11
How can i compare two Lists for identical links?
- 12
How can I merge multiple Streams into a higher level Stream?
- 13
How can I pipe the output of an Akka Streams Merge to another Flow?
- 14
In R, how can I merge two data.frame columns using parentheses () as separation?
- 15
How can I merge rows and columns from two sql tables into one table
- 16
How can I merge two JObject?
- 17
How can I efficiently merge these two datasets?
- 18
How can I merge two vectors?
- 19
How can I merge two arrays into a dictionary?
- 20
How can I merge two shapes in svg?
- 21
How can I merge two folders in Windows?
- 22
How can I Merge two JavaScript objects?
- 23
How can I know when two Streams are done?
- 24
How can I wrap text into two columns?
- 25
How can I make two columns with a RecylcerView?
- 26
How can I combine two columns in pandas
- 27
How do I merge two columns in a dataframe based on a datetime index?
- 28
How do I merge two Excel columns into one?
- 29
How to SQL Merge when I need to match two columns
Comments