Split

To add an output:

1. Click the Add button. The Output Properties dialog box opens:

2. Determine unique identifier of the input in the Identifier box.

3. Use the Link to Object drop-down list to select the consumer, to input of which data from transformer object is loaded.
   After the object is selected, it is prompted to fill in the list of fields from the linked input.

The output linked with specified object will be created.

To edit output:

1. Select the required output.

2. Click the Edit button. The Output Properties dialog box opens:

3. Edit identifier.

4. Use the Link to Object drop-down list to change the consumer, to output of which data from transformer object is loaded.
   After selecting or changing the object, it is prompted to fill in the list of fields from the linked input.

The output parameters are changed.

Duplication enables the user to create a copy of the output created previously.

To duplicate output:

1. Select the existing output.

2. Click the Duplicate button. The Output Properties dialog box opens:

The copy of the specified output is created.

To delete output:

1. Select the required output.

2. Click the Delete button.

The output is deleted without showing confirmation dialog box.

To create a field:

1. Select the required output. The output fields are displayed at the bottom of the dialog box.

2. Add a field to the list:

• Click the Add button.

• The INSERT key.

• Double-click a free area.

The dialog box opens:

3. Edit identifier and name. They are equal by default.

4. Select the required field type in the drop-down list according to consumer data type.

The field with specified parameters is created.

To edit field:

1. Select the required output. The output fields are displayed at the bottom of the dialog box.

2. Select the required field or fields form the list.

TIP. For multiple selection use the CTRL+A key combination or hold down the CTRL key. It enables the user to change simultaneously the data type of all selected fields.

3. Click the Edit button. The dialog box opens:

4. If required, edit identifier and name. On multiple selection of fields, it is impossible to edit identifier and name.

5. If required, change type of field or fields in the drop-down list.

Parameters of field or fields are changed.

To delete a field:

1. Select the required output. Provider or consumer fields are displayed at the bottom of the dialog box.

2. Select the required field or fields form the list.

TIP. To delete multiple fields, use multiple selection with the CTRL+A key combination or hold down the CTRL key.

3. Click the Delete button.

The field is deleted without showing confirmation dialog box.

Autofilling fields enables the user to generate quickly the list of fields on the output of the Split transformer.

To autofill fields:

1. Select the required output.

2. Select one of the Fill From button items:

• From Provider. Fields from data provider are added to the list.

• From Consumer. Fields from data consumer are added to the list.

Fields from data provider or consumer are added to the list.

To add a condition:

1. Click the button. The Expression Editor dialog box opens.

2. Generate the required condition, for example, I1.DATE = "Summer".

To edit a condition:

1. Click the button. The Expression Editor dialog box opens.

2. Modify a condition.

To delete a condition, click the button. The condition will be deleted without displaying confirmation dialog box.

To add a link between input and output fields:

• Select the required field in the Source Fields and in the Input and Output Fields Mapping columns, click the Link button.

• Drag the required field from the Source Fields column to one field of the Input and Output Fields Mapping column.

NOTE. To quickly add a link between all input and output fields, drag an input from the Source Fields column to an output of the Input and Output Fields Mapping column.

To add links automatically, click the Automatically button. This action leads to linking of all output fields with input fields according to identifiers and field types.

To edit link in the Input and Output Fields Mapping area:

1. Select the required field:

• Click the Edit button.

• Double-click the selected field.

2. The Expression Editor dialog box opens. Modify an expression.

To delete a link in the Input and Output Fields Mapping column:

1. Select the required field or output.

2. Click:

• The Clear button.

• The DELETE key.

The link is deleted without showing confirmation dialog box.