Icon

Regex Multi Row Splitter

Options

Output port map as flow variable
If selected, creates a flow variable "regex-splitter-port-map" containing the port mapping for ports 1-10. This is useful as a visual confirmation of the filters that have been applied
Retain Original RowIDs
Select if you want to retain the RowIDs from the original table. If not selected, each output table will be allocated new RowIDs
Cascade filtering
If Cascade Filtering is selected, rows are removed from the remainder of the available filters as soon as they have matched a pattern. With this selected, a row may only appear on one of the output ports. If the final output port has a regex pattern of .* it will act as a catch-all filter.%%00010%%00010Internally, Cascade filtering uses a sequence of chained Row Splitter nodes to filter each pattern and then pass on only the non-matching rows to the next Row Splitter which then uses the next pattern in sequence. In this mode, a row can appear in at most one output port. %%00010%%00010With Cascade Filtering OFF, internally it the patterns are each tested by a series of Row Filter nodes which execute separately from each other. In this mode, a row can appear in multiple output ports.
Row Split Column
Select the column to be used for determining the splitting of rows
Row Split patterns
Enter the row split patterns (regex). %%00010%%00010One per line with each line representing an output port.

Input Ports

This node has no input ports

Output Ports

This node has no output ports

Nodes

Extensions

Links