2019.1

Output
Multiple data files, sent one after the other to the rest of the tasks in the process. Metadata, job
infos and user variables are not modified by this task.
Task properties
General Tab
l
Split group: Use this group to indicate how you want the file to be split.
l
Field value change: Select if you want the file to be split based on changes in the values
of a selected database field (the value in the ClientID field changes, for example).
l
Field value condition: Select if you want the file to be split based on a condition set for
the values of a selected database field (the value in the Order field equals 1, for example).
l
Field count: Select if you want the file to be split whenever a given number of pages or
data pages has been reached.
The following options are only displayed when the Field value change or the Field value
condition option has been selected at the top of the dialog box.
l
Field: Enter the name of the field upon which to base the splitter condition. Note that you
can use the popup menu's Get Data command to select the field and populate this box
automatically.
The following options are only displayed when the Field value condition option has been
selected at the top of the dialog box.
l
Operator: Select the condition to fulfill for the condition to be true and thus for the splitting
process to take place.
l
Value: Enter the condition value. Note that you can use the popup menu's Get Data
command to select the value and populate this box automatically
l
Match case: Select to force the splitter to match the character casing when resolving the
Field value change or Field value condition. If this option is selected, a change from
“DAY” to “Day” will be considered as a valid field value change, and “DAY” and “Day” will
not be considered as equal values.
l
Where to split group: Options from this group are used to define a number of pages or
records before or after which the file is to be split.
Page 440