Compare 2 table columns

[adjrock]

Hi,
I have 2 tables with varying number of columns between them. Problem is there are too many to make it easy to visually find which columns is not in left data set and vice versa. Is there a simple node that can do that?

[armingrudd]

Hi,

I think the “Reference Column Filter” will do what you need.

You can use one of the tables as the reference table and exclude columns in the main table (the other table) which also exist in the reference table, so the remaining columns are those that do not exist in the reference table. Then use the other table as the reference table and do vise versa.

Best,
Armin

[morpheus]

Hi,
try the “Extract Column Header Node”, Transpose the upper outputs and join both results with “full outer join” method.

Best,
Hermann