When you create a new data flow and select a data set, you'll see a step with the name of your data set. You can add additional data from multiple data sources to your data flow.
Use the Add Data step in the data flow editor. If you've created a new data flow project, your data set will be selected.
- Use the options on the Add Data pane to configure the data set. For example, change the default name, or include and exclude columns.
- To add another data set to your flow, click Add a step
(+), and select Add Data.If matching columns are found in data sets, a Join step is automatically added to enable you to define the relationship between the data sets. For example, you might want to combine rows from two data sets where the
CustomerIDin the first data set matches the
CustomerIDin the second data set.
- If you don't get a Join step automatically, click Add a step
(+), and select Join.To complete the join, on the data flow diagram click the circle on the dotted line between the data source step and the Join step. Then use the Join pane to configure the relationship between the data sets
- Click your data set step again and use the options on the Add Data pane to configure the data set.
Field Description Add Data - <Data source name> Click this pane heading to edit the step name and description. Select... Use this option to change the data set or data source. Changing the data set or data source might break other steps in your flow. When Run Prompt to select Data Set Select this option to supply the name of the output data set when the data flow is executed. For example, you might want to specify a different name for the output data set each time the flow is executed.