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.
The Compose shape outputs one record for every incoming data record after it is enhanced with additional data. This data is mapped to an embedded page or a page list of the incoming record. The input and output class of the data record remain the same.
For example, to create a record that contains the full customer profile for a call center interaction, your compose conditions can look like this:
Compose Customer with data from Subscription into
Property .Subscriptions
When CustomerID is equal to .CustomerID
The Customers data set contains basic information about the customer that needs to be combined with data in the Subscriptions data set.