I have several tables, each with the same structure.
I want to create a combined table, where all the rows with a perticular value match for a specific column.
1. I created a new table
2. activated two columns ( say column 1 and 2)
3. inputed the same value in both the columns (say 10 and 10)
4. Clicked join; Matched Table 1 with column 1 and Table 2 with Column 2.
The result looked as if it was successful, however the data from Table 1 got partially writtenover by Table 2.
Is there some way to fix this ?
Thanks and Regards