Split By Pattern - Data360_Analyze - 3.12

Data360 Analyze Server Help

Data360 Analyze
Product family
Product name
Data360 Analyze
Data360 Analyze Server Help
First publish date

This deprecated node splits an input set into two outputs based upon whether a designated data pattern expression matches any field values.

This node has been deprecated and will not be supported in a future release. As an alternative, the Split node can be used to provide similar functionality.

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.



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.


Specify a regular expression to match against the fields specified in Fields.

A value is required for this property.


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.