Join Data Sources

tell me more icon Tell me more.

Use a Join node to combine the aggregated sales data and the customer data to create a data source for building models.

Follow these steps to create the join:

  1. In the Component Palette, click the Transforms section, and left-click Join. Move the cursor to the workflow and click again. Name the node JoinData.

  2. Right-click CUSTOMERS, select Connect, and connect CUSTOMERS to JoinData.

  3. Right-click AggregateSALES, select Connect, and connect CUSTOMERS to JoinData.

  4. Double-click JoinData. The Edit Join Node dialog opens.

  5. Click add join definition. The Edit Join Column Dialog opens.

  6. Select CUSTOMERS as Source 1 and AggregateSALES as Source 2.

  7. Select CUST_ID in Source 1 and in Source 2.

  8. Click Add to add CUST_ID to Join Columns. Note that the dialog determines that the Join Type is Inner.
    tell me more icon Tell me more about what I see in the GUI.

  9. Click OK to return to Edit Join Node, and then click OK again to complete the join specification.

  10. Right-click JoinData and select Run to create the join.

The cue cards icon Next step is to create a table and build classification models.