Merge with Full join

[AndreaM]

Hello everyone,

I’ve got two tables and I need to know which columns exist only in one of these two tables.
To do so:
1- I imported the two tables;
2- Throught the “Table metadata” action I choose the columns names;
3- I go Merge with Full Join to find the exclusive columns;

The problem is that I’ve got a wrong result:

Why it shows a “Col3” under Tab_A_Columns?

[dgudkov]

@AndreaM

Why it shows a “Col3” under Tab_A_Columns?

Because it not only matches but also merges the lists of columns A and B.

@AndreaM

I need to know which columns exist only in one of these two tables.

I would suggest using the "Keep/remove matching" action in the "Remove" mode for this. "Merge" is for merging data. "Remove matching" is for finding the difference.