Hi, I have table where I would like to detect a pattern in a cell and then filter out all of the rows above that cell.
In the example table below I want to use regex to find the pattern ‘B’ in the ‘Label’ column. I was then hoping to use the rowID node to store that location and then use that value as a flow variable to filter rows above or below that value. Is this possible?
Example Table:
Label Value
A 2
B 3
C 8