1. In your example, there will be only Table1, because Table2 will automatically concatenate to Table1 due to similar columns.
2. If you want to load only values that are not present already in a loaded column, use EXISTS()
not EXISTS( Column1);
i changed the example to show two distinct datasets, in my case they would not be merged as these temp tables are never consumed in the ui this is part of a process to build a qvd.
that being said, how does, where not exists (column1) reference the different dataset?
I want to load everything into resident table3 where the column7 does not contain any of the loaded values in temp table2 column4.