Thanks for the solution, but in my case i want to keep Table1 and Table2 also. If i remove the drop tabel i got synthetic keys which i dont want. When i use Qualify on Table1 and Table2 i got no synthetic keys but the VTable is exploded and when i use Unqualify on the VTable the synthetic keys are back.
The only solution seems to load the data 2 times, 1 for the join and 1 for the Qualify which only can come after the join. With the following code i got a corrrect joined table and the two indivdual tables. In my mind i would expect to first load the indivudual tables and then join and still keep them all without the synthetic keys.