Reference column filter with regex

[rd2575691]

Hello,

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?

Thanks

[armingrudd]

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.

[rd2575691]

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)