Sorry if this subject has already been treated, but I can't fin it.
I have 2 tables, they have 2 identical column, the third is different. They don't have the same number of rows. I'd like to make a "union" using the common columns, add the different columns and get all the data in one table.
So I use the "union" node and select the common columns, but it doesn't work as I wish. I think, the easiest way to explain the result is an example.
I hope it's clear. I don't see any other solution.
Thanks for your help