Adding the Data Splitter component to a project opens a component window that displays inbound data attributes and output port conditions.
The Data Splitter component is configured with two output ports. Both port conditions are preset to 1. Since this condition is always true, regardless of the current values of the input port, the Data Splitter copies all incoming records to both output ports.
The input port data buffer is initially empty, and only the inbound data attributes are visible. The output port structures match the input port structure.
To populate the input attributes, click the Step to the next input buffer icon on the toolbar. Input data appears in the upper part of the component window.
Since the output ports share the same port structure as the input port, selecting any record in the upper window causes the output port to indicate whether the record meets the port condition. When a record meets port conditions, the output port color is green. When a record does not meet port conditions, the output port color changes to red.
Inclusive Port Conditions
If the splitter mode is inclusive, that is, you have not defined mutually exclusive port conditions, each input record is tested against each port condition. For every matching port condition, a copy of the current record is written to the output port.
Exclusive Port Conditions
If you have defined mutually exclusive port conditions, ports are evaluated based on a user-specified order, instead of the order in which they appear on the component. The conditions are evaluated in order of first to last. The first output port with a matching condition receives the input record. No further port conditions are evaluated. You can change the evaluation order of conditions by clicking the Edit evaluation order icon and then swapping rows in the Evaluation order window. Click the Reset evaluation order icon to reset to the default order.
The number of records that Data Splitter forwards to the output ports can differ from the number of incoming records. If the port condition is not defined as mutually exclusive, when a single record matches more than one port condition, it is available on all of these ports. Records that do not match any of the conditions are removed from the data stream. For mutually exclusive port conditions, a single input record can match only one output port. Records that do not match are not written to any output port.