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.

  1. In a data flow, click the Plus icon on a shape, and select Compose.
  2. Double-click the secondary Source shape to configure it. For example, Subscriptions data set.
    Note: When you select a data set, it must be a data set that you can browse by keys, for example, Database Table, Decision Data Store, Event Store, HBase, or Interaction History data set.
  3. Click Submit.
  4. Double-click the Compose shape to configure it.
  5. In the Name field, enter a name for the shape.
  6. Select a property in which you want compose data from your sources. For example, .Subscriptions.
  7. 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.
  8. Click Submit.
Example: 

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.