Create Multiple Pipelines in a Data Flow Using a Branch

Creates multiple outputs from a data flow using a branch. For example, if you have sales transactions data based on country, you might save data for United States in the first branch and data for Canada in the second branch.

Use the Branch step in the data flow editor.

1. Click Add a step (+) and select Branch.
   You'll see a Branch step and two Save Data steps added to the data flow. Select the Branch step and use the Branch into option to add or remove branches. The minimum number of branches is two, and the maximum is five.
2. To configure each branch, click connection line between the Branch step and the Save Data step, click Add a step (+) and select a step type that processes your branch.
   For example, you might add a Filter to the first branch that saves data from United States, and add a Filter to the second branch that saves data from Canada. Or, you might use the Split Columns step to save some columns in the first branch and other columns in the second branch.
3. Click each Save Data step and in the Save Data Set pane specify the properties for saving the output data sets.