Column Filter based on column names

Hi Team,

Does anyone know how do I filter columns based on column names.

For example, in the below column names i want to filter columns ending with Act and Est.
ColumnAct ColumnEst Column2Act Column3Est ColumnTotal Columnstick

that is output table:
ColumnAct ColumnEst Column2Act Column3Est

*Number of columns keep changing, So I cannot apply the normal column filter
Thank you in advance!

Best regards,
Sahil

Hi @Sahil1,

you can use the Wildcard/Regex selection in the column filter.

Here is also a good video on how to use the column filter node.
Cheers,
Johannes

3 Likes

Thanks Johannes!

Best regards,
Sahil

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