Reference column filter with regex


If the sample dataset has subset of column names eg: (A,B,C) from the main file having (Column A, Column B, Column C, Column D, Column E …), and has to be filtered using pattern matching or regex, is there something like Reference column filter that can help?


Hi @rd2575691,

I have a method to solve your issue using the Column Filter node:

reference_filter_regex.knwf (46.6 KB)

I have used a very simple regex regarding your simple examples. If you need something different, provide some real examples.



Thanks @armingrudd. Will try it out. Meanwhile attached a sample, hope its useful.
It has three tabs where “Main” is filtered using the “Sample” input to get the “Output”.
sample.xlsx (10.0 KB)

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.