Combining data from two sources
Combine data from two sources into a page or page list to have all the necessary data in one record. To combine data, you need to identify a property that is a match between the two sources. The data from the secondary source is appended to the incoming data record as an embedded data page. When you use multiple Compose shapes, the incoming data is appended with multiple embedded data pages.
- In a data flow, click the Plus icon on a shape, and select Compose.
- Double-click the secondary Source shape to configure it. For example,
Subscriptions data set.
- Click Submit.
- Double-click the Compose shape to configure it.
- In the Name field, enter a name for the shape.
- Select a property in which you want compose data from your sources. For example, .Subscriptions.
- Click Add condition and select a property that needs to match between two sources. You can add more than one condition. For example, When .CustomerID is equal to .CustomerID.
- Click Submit.
Previous topic Filtering incoming data Next topic Converting the class of the incoming data pages