2018.1

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.
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 that matches the set condition. Select Records after if you want the file to
be split a given number of records after the field that matches the set condition. Select
Page 324