Column Filter using Variable

In my workflow I use R script to decide about the most important attributes of my dataset.
I end up having these (20) attributes in a table (1 Column, 20 Rows).

Now I want to apply Column filter to my original dataset, what is the best way to do that?

I have been playing around with “Value Filter” and “Table Column to Variable” but with no hope.
So far I have managed just to see the variable with the 20 columns in other nodes but how am I supposed to filter my dataset using this variable?

1 Like

Hi @karapapas,
you can do that by first turning your column names into row IDs using the RowID node, then Transposing the table and finally using a Reference Column Filter to only keep the wanted columns from the other table. Please see attached workflow, which shows how it is done.
Kind regards

column filter.knwf (11.1 KB)


Great answer! It worked and it worked nicely. Thank you so much!!


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