flow variable to exclude column via column filter

[l.thomas]

Dear all,
I managed to use a string collection flow variable together with a column filter node and the option Enforce inclusion to set the columns to include, however I tried the opposite: setting the flow variable to set the column to exclude, with the enforce exclusion but it does not seem to work.

This was originally proposed in this related discussion

How to filter columns using flow variables?

I don't think it's a mess, controlling the columns works exactly as expected. If you set "Enforce inclusion" only the list of included columns is used during execute. Therefore, changes to the exclude list don't have any effect. If you override one of the included columns then the output changes accordingly. The opposite is true for "Enforce exclusion": the include list is completely ignored, only the exclude list matters. All columns not present in the exclude list will end up in the output tab…

Here is an example workflow demonstrating a branch for inclusion and exclusion.
FilterWithVariable.knwf (13,6 Ko)

[ipazin]

Hello @l.thomas,

follow same approach as for Column Filter where you use flow variable to control included columns. Add all columns to excluded list and check Enforce exclusion.

Br,
Ivan

[l.thomas]

I see ! I was missing that bit:

@ipazin

Add all columns to excluded list

thanks a lot !