When you add data from multiple data sources to your data flow,
you can join them on an common column. For example, you might join an
Orders data set to a
Customer_orders data set using a
customer ID field.
- Add the data sources you'd like to join.
- Select a data source, click Add a step, then click
Join.You'll see a suggested connection with a node on the connection line.
- Click the node on the connection line to complete the connection.
- Use the options on the Join pane to configure
Field Description Keep rows Use these options to specify how you want to join your data. Click an option to preview your merged data (if you're displaying the Data Preview pane). Match columns Specify the common field on which you'd like to join the data sources.