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.
- 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.
- 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.
- Click each Save Data step and in the Save Data Set pane specify the properties for saving the output data sets.