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
Alexander

column filter.knwf (11.1 KB)

5 Likes

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

2 Likes

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