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?
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