Subscribe Bookmark RSS Feed

How to join multiple table using a match option

none1

Community Trekker

Joined:

Apr 9, 2014

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