| Info | ||||
|---|---|---|---|---|
| ||||
Combining 2 sets of data that are a similar size and have a common key. For each pair of matching records from the data sets, a single record is produced in the output. |
| Info | ||||
|---|---|---|---|---|
| ||||
Comparing a stream of thousands of invoice totals with a stream of thousands of payments for each customer. |
In order to merge 2 sets of data into 1 set of data (the equivalent of a join in SQL), add a pull pipe from each of your source streams to the result stream. Group your pipes by the key fields. The key fields should contain the same sort of data in the same format in both source streams, but do not have to have the same attribute names. The below screenshot shows 2 pulls pipes that have been configured to create a merge on 3 key fields.
...