Configuring a Conditional Router - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
Copyright
2024
First publish date
2007
Last updated
2024-10-11
Published on
2024-10-11T22:55:47.128293

  1. Under Control Stages, click on Conditional Router and drag it to the canvas, placing it in the desired location within the flow.
  2. Connect the router to other stages on the canvas.
    Note: This is a mandatory step before defining the port settings. Otherwise the ports are not available for editing.
  3. Double-click on the Conditional Router stage on the canvas.
    The Conditional Router Options window appears.
  4. Click the square button in the Condition/Expression column against the port row.
    The Expressions Editor window appears.
  5. In the Choose Expression Type section, select one of the following:
    • Expression created with Expression Builder: Select this option to create a basic expression, where you can add Groups and Expressions, which can be combined using different logical operators. For more information, see Using the Expression Builder.
    • Custom expression: Select this option to write an expression using the Groovy scripting language. For more information, see Writing a Custom Expression.
    • Default expression: Select this to route records to this port by default. Records that do not match any of the other ports' expressions will be routed to this port. You should always have an output port with "default" as the expression to ensure that no rows are missed in case of a port mismatch, and all rows are written from the router.
  6. Click OK. The Expressions Editor window closes.
  7. Click OK on the Conditional Router Options window.