Filter Column based on entries of other table

Hi

I have a table with certain columns and I would like to filter only some of the columns. The names to be selected is in an other table.

Is there a node or a way to do this without using python.
The tables look like this:
Table 1:Contains the names of columns in rows
image
Table 2: Table to be filtered only on columns in table 1

Thanks for your help
BR

Hello @sschacht,

you can use Pivoting node where pivoting column should be your CName column from table 1. Define Column name as Pivot name and Aggregation name as Keep original name(s). Then apply Reference Column Filter node.

Br,
Ivan

1 Like

Thanks for your Idea. But I am not able to configure the pivot node without error “Ambigious group/pivot column selection”
My configuration looks like this:

and Pivot Screen

Thanks for your help.
BR

Hello @sschacht,

you can’t have same column as grouping and pivoting column. In your case you don’t need grouping column as only thing you want is to have values from CName column as column name so you can use Reference Column Filter node. Make sure to add any column into Manual Aggregation as node can’t be configured without it.

Br,
Ivan

Perfect, it works. Thanks

1 Like

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