| Info | ||||
|---|---|---|---|---|
| ||||
Combine data from 2 sources into 1 set of data. For each record in each data set, you get one record. |
| Info | ||||
|---|---|---|---|---|
| ||||
You have a set of customers stored in one system. You have a set of customers in another system. There are no overlaps. You want all your customers in one list. |
The below screenshots shows how you can combine 2 data sets to create a single data set containing all records from both. (i.e. the equivalent of a union in SQL). To do this have the 2 calculate streams pipe into a single merge stream. The same principal applies if you are also combining more than 2 streams.
...
If your attribute is called something different in each source stream, then you will need to check the pipe name to work out which attribute to use. This is shown in Attribute3 in the screenshot. _pipeName is an internal variable that stores the pipe name of the current record.Further explanations/ examples can be found here:
| HTML Comment | ||
|---|---|---|
| ||
When how to articles come over: See also /wiki/spaces/CONFIGKB/pages/97734760 |