Mark Blocks in Table

Inspects two columns in a table. One column denotes the start of the block and the second denotes the end. Specifying the same column for both is allowed.

The component looks for a start marker and an end marker in the respective columns. For all the rows in between the start and end markers, a unique block number is assigned in the appended output column

Options

Remove marker columns
Select this option to remove the two marker columns from the output table
Block-start marker column
Choose the column containing the block-start marker
Block-end marker column
Choose the column containing the block-end marker
Block finishes...
Choose whether the block finishes on the row containing the end marker, or the row before. %%00010If the end marker and start marker are on the same row, the block will be deemed to end on the row containing the end marker regardless of this selection.
Block starts...
Choose whether the block starts on the row containing the start marker, or the row after. %%00010If the end marker and start marker are on the same row, the block will be deemed to start on the row containing the start marker regardless of this selection.
If start/end rules conflict...
Choose what to do if the rules conflicte.g. where the start and end markers are on the same line or consecutive lines, and the rules say to start AFTER the start marker and/or end BEFORE the end marker
Block Start Regex
Enter the regex denoting block start
Block End Regex
Enter the regex denoting block end
Block Number Column to append
Enter the name of a new column in which to insert the block number

Input Ports

Icon
Input table containing block identifiers

Output Ports

Icon
Output table with column defining block numbers for every row within each block

Nodes

Extensions

Links