Complex Split by Size

Overview

The Complex Split by Size macro processes a complex record hierarchy such that no FILE contains more than COUNT records of a given __Type. When it encounters FILE hierarchies containing more than the allowed number of __Type records, it replicates the ancestry of the records being split and generates new FILE records for them. It also replicates the records that are descendants of the replicated ancestors but not descendants of the __Type records (the "aunts and cousins").

Complex Split by Size macro configuration parameters

The Complex Split by Size macro has a single set of configuration parameters.

Parameter

Description

Record type to split on

Value of the __Type field indicating records to be counted.

Default: 100

Split count

Maximum number of records of specified __Type that can be included in a single file.

Default: 50

File pattern

Path and name of split output files. The file name is constructed using the text variables %SEQ% for sequence number and %COUNT% for record count.

Default: f:/temp/output_file_%SEQ%_%COUNT%.xml

Configure the Complex Split by Size macro

Select the Complex Split by Size icon.
Go to the Configuration tab on the Properties pane.
Select Record type to split on and enter the value of the __Type field indicating records to be counted.
Select Split count and enter the maximum number of records per output file.
Select File pattern and edit the path and file name for the split output files. The file name will be constructed using the text variables %SEQ% for sequence number and %COUNT% for record count.
Optionally, go to the Execution tab, and then set Web service options.