Filtering Based on a List
I want to use a column filter that filters based on a list of column names provided in a column from another table.
I am trying to use the method described in this post:
https://forum.knime.com/t/filtering-columns-based-on-a-list/66161
And this post:
#Filtering columns based on a List type of Column Names
But I can’t seem to get it to work. It only excludes the first column name I specify. Here is a small example of what I am trying (workflow attached)
Here is the starting data files with 6 columns.
Here is the reference table with included and excluded fields. Note that [Sales] is in the excluded column.
Here is the Table Row To Variable node
Here are flow variable settings for the Column Filter:
Here is the node settings for Column Filter. Note that [Sales] is showing up in the Included set.
And here is the output of the column filter node (Sales is still present):
If I switch the order of Name and Sales in the table specifying what is excluded, that same thing happens (Sales are excluded, Name is included). So this is apparently only using the first row.
Any ideas of what I am doing wrong, here?
Thanks!