2022.2

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 val-
ues 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 pro-
cess 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.
l
Pages or records: Enter the number of pages or records before or after which the file is to be
split. Enter 0 if you want the file to be split right before or after the page or record that matches
the set condition.
l
Before or after: Options from this list box are used to define exactly how the file is to be split.
Select Records before if you want the file to be split a given number of records before the field
Page 407