The bottom portion of the window is where the data splitting
conditions are developed by drag and drop operations. The variables used
Using a Conditional Split Data Transformation
[ 138 ]
in splitting, and the operation needed to fashion the split can both be dragged
and dropped. The way the splitting is configured is shown in annotation. In
this part of the window, the name for the split is provided in a drop-down
list. There is also a provision to order the split by using the arrows on the
right, and a button that will take you to configure the default of a conditional
split transformation.
2. Click under Output Name and type in the name "Case 1" for this example,
the Order field gets populated with 1.
Chapter 8
[ 139 ]
3. Now following the schematic (red, blue, magenta instructions) in the above
screenshot, format Discount > 0 in the Condition column.
4. Using the same procedure, create Case 2 below Case 1 with Discount <= 0.
By default, Case 1 will be the first and Case 2 is the second in order. This can
be changed by using the up/down arrows at the far right of the window.
5. Provide the name, "SplitDefault", for the Default Output name.
In this particular example, we will not configure an error output. The
completed window appears as shown in the following screenshot.
6. Click on the OK button to complete the Conditional Split Transformation.
The Conditional Split Transformation will be producing three outputs, one each for
Discount > 0, Discount <= 0, and the default that is neither of the two.
Pages:
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110