...
- Add a new merge stream to hold the merged data.
- Connect the source streams to the merge stream using pull pipes e.g in and in2
- Drag all the non-key attributes from the source streams into the destination stream i.e all attributes except the one(s) that will be used to define the key of the records.
- Hover over the destination stream and select Quick Configure Options->Configure Input
- For each of the source streams displayed, select Show the List of Attributes and drag the key attribute into the box below
- Save the changes
- Now add a new attribute to the destination stream for the key. In the attribute expression type _key
- Run the destination stream. The results will contain one record for each unique key in the source streams, with attributes from all source streams
Example 2: Merging customers and accounts using the Merge feature
...