It is often useful to merge two or more streams of data to add additional attributes for records from another source and / or to identify duplicates and missing records. The examples below show how to do this manually to understand the process as well as using a built in feature of PhixFlow that provides some useful additional attributes on the merged data.
The model for these examples is 001 Merge Streams
Example 1: Manually merging customers and accounts
...
- Select the source streams by right clicking on them whilst holding down Shift
- Right click on the model background and select Merge Selected Streams
- For each of the source streams displayed, select Show the List of Attributes and drag the key attribute into the box below as in example 1
- Save the changes and select All attributes in the automatic stream configuration screen
- The stream will now be configured with additional attributes as shown below:
- gridRowColor = Highlights rows in red if there are multiple records / duplicates
- in_Count & in_2_Count = Reports the number of records matching they key in each of the source streams
- in_HasDate & in_2_HasData = Reports whether or not a matching record was found in each stream
...
Model Ref: 001
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...