filtering columns based on a list

Hi All,

I need to filter out some column, but the list of columns to keep can change, therefore I created a list that contains those and tried to use it in column filter-node as “included names” variable.
Unfortunately it doesn’t work.
I attached a workflow to show how I tried it.
Can you pls help me, why, and what would be the right name to do it ?
Thank you
column filter from list.knwf (11.9 KB)

Hi @HarryKl

This is the right way to do it. Move your columns to the Exclude section and it will work as intended :wink: It basically needs values to be present to apply the flow variable to.

Note that you mention include names in your post but you applied it to exclude names. In any case, the usage of the flow variable (include names/exclude names) and in which section the columns are should match (include/exclude).

2 Likes

got it.
Many thanks for the help.

1 Like

There is also a reference column filter node
br

3 Likes

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