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 in the list.

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

3. Edit identifier.

4. In the Link to Object drop-down list select or change the consumer object, to input 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.

After executing the operations, the output from the consumer object and/or its link to the transformer is 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 operation confirmation.

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.

• Press the INSERT key.

• Double-click the empty 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 the 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 in 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 in 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 displaying 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 Add Condition button. The Expression Editor dialog box opens.

2. Create a necessary condition that will return a logical value. If the condition returns True during ETL task execution, data is sent. If the value is False, data is skipped.

 For example, to split the above mentioned data, the first condition is: I1.DATE = "Summer", and the second condition: I1.DATE = "Winter".

To edit a condition:

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

2. Edit a condition.

To delete the condition, click the Delete Condition button. The condition will be deleted without operation confirmation. When the conditions list changes, their numbering changes automatically.

To add a link between input field and output field, execute one of the operations:

• Select the required field in the Source Fields area, the required output field in the Input and Output Fields Mapping area and 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. Input fields will be linked with all fields of all outputs, which have the same identifier and data type.

For example, the link for the second condition for the specified data should be set up as follows:

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

1. Select the required field, click the Edit button or double-click the required field.

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

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

1. Select the required field or output.

2. Click the Clear button or press the DELETE key.

The link will be deleted without operation confirmation. If the output was selected, links for all its fields will be reset.