2020.2

Database Splitter
The Database Splitter is used to split database files into multiple data files that are passed to
subsequent tasks in the process.
Input
Database data (see "Database emulation" on page64).
Processing
The file is separated into multiple chunks according to the rules set in the task's properties.
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.
Page 446