Modeling Guide

Case

The Case node specifies multiple paths so that the rows are separated and processed in different ways.

Prerequisites

You have added the Case node to the canvas, connected the previous node, and clicked the Configure (gear) icon.

Context

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.

Procedure

  1. (Optional) Choose 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.
  2. (Optional) Click + to add more Case output ports and expressions.
  3. Click the name under the Case heading to rename the port to be more meaningful. For example, Canada_Customer.
  4. Click the link under the Expression heading to open the Expression Editor.
  5. In the Expression Editor, define an expression for the records that you want to include in this output, and then click Apply.
  6. After defining all the expressions for each output port, click Apply to return to the canvas.