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
...
- 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) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...