TRANSFORMER

Splitter

The Splitter process separates the data into different streams, according to selection conditions you specify. The Splitter object ends in one new connection per condition, which in turn can either lead to further processing or to a target. There is no practical limit to the number of conditions you can have.

Creating a Splitter process

To create a Splitter process, right click in the Transformer design panel, choose Process -> Splitter. Connect it to the previous process as described in Processes.

Properties

General

Name - the name "Splitter" is generated automatically but it may be changed
Description - an optional text describing the process

Audit

Modified by - the name of the last user to make changes to the object.
Last modified - the date and time when the object was last changed.
Created by - the name of the user who created the object.
Created - the date and time when the object was created.

Custom

One Condition is created by default, and you see it when you open the Custom tab. To configure it double click the red field under Conditions to activate it, then click the icon that appears on the right. This will open the Calculator that can be used to set up the selection conditions. Click OK when you have defined the condition.

E.g. if you want to treat all records belonging to Organization A separately the Condition to use is ${org}="A". Enter this directly in the Function field, or double click "org" in the Fields panel, click the "=" button and then double click "A" in the Unique values panel.

To create another condition, right click in the empty area below the Conditions in the Splitter configuration dialog and choose Add new.

To delete a condition, right click it and choose Remove selected.

Click OK when you have defined the Conditions you need. Add a connector and a process or target for each condition in the Splitter. The records that satisfy the first condition will be sent to the first stream, those that satisfy the second condition will be sent to the second, and so on. The connectors will be numbered to help you keep control.