Configure the Case Node
The Case node specifies multiple paths so that the rows are separated and processed in different ways.
You have defined the operator with a Case node and connected the previous node to the Case node.
Route input records from a single source to one or more output paths. You can simplify branch logic in data flows by consolidating case or decision making logic in one node. Paths are defined in an expression table. By default there are two output ports defined. The one ending in Default contains any records that do not meet the expression definition in one of the other output ports.
- Double-click the Case node.
(Optional) Select Output Row Once to specify whether a row can be
included in only one or many output targets.
For example, you might have a partial address that does not include a country name such as 455 Rue de la Marine. It is possible that this row could be output to the tables named Canada_Customer, France_Customer, and Other_Customer. Select this option to output the record into the first output table whose expression returns TRUE. Not selecting this option would put the record in all three tables.
- (Optional) Choose + (Add Port) to add more Case output ports and expressions.
- Click the name under the Output Port Name heading to rename the port to be more meaningful. For example, Canada_Customer.
- Click the link under the Expression heading to open the expression editor.
- In the expression editor, define an expression for the records that you want to include in this output.
Define the default port.
The default port contains any records that do not meet the expression definition in one of the other output ports.
- Select the required output port and choose Default.
If you want to configure the Data Transform operator with another node,
- In the menu bar, use the breadcrumb navigation to navigate back to the operator configuration editor.
- Add new nodes.
- To connect the nodes, select the output port of a node and drag the cursor to an input port of another node.