This deprecated node splits an input set into two outputs based upon whether a designated data pattern expression matches any field values.
Records that match the pattern are output on the top pin while records that do not are output on the bottom pin. If multiple fields are specified, the node can verify that either all fields match the pattern or that at least one field matches the pattern. In the second case, the node will short circuit, or stop evaluating additional matches, once the first field match is found.
Among other uses, this node would be useful in cleaning extracted data by identifying records that might need manual revision or that would require additional clean-up logic. For example, this node could verify that all inventory IDs contain three letters followed by a dash, then four digits, and possibly an optional two letter extension preceded by a final dash. Those that do not conform to this pattern would be output on the lower pin to be reconciled against the part information database.
Properties
Fields
Specify a comma separated list of fields to check against Pattern. Each field name must be surrounded by single quotes (').
A value is required for this property.
Pattern
Specify a regular expression to match against the fields specified in Fields.
A value is required for this property.
MatchAllFields
Optionally specify whether all the fields in Fields must match Pattern in order for a row to be output to the top pin. When this property is false, at least one of the fields in Fields must match Pattern in order for a row to be output to the top pin.
The default value is False.
When this property is false, evaluation of matches stops on the first matching field. All subsequently specified fields are not compared to Pattern.
Inputs and outputs
Inputs: in1.
Outputs: true, false, multiple optional.