Forum Discussion
Merging two tables without duplicates based on certain data
I need to join two tables (add the Purchose order column to the table 1) by matching part number and serial number and copy the column with the corresponding purchase order number in table 2.
Note: The column names of the part number and the serial number is different in two tables.
Table 1
| Part number (PN) | Serial Number (SN) | Lot no | Quantity |
| A | X | A110 | 1 |
| A | Y | A111 | 2 |
| A | Z | A112 | 2 |
| B | J | A113 | 1 |
| B | K | A114 | 1 |
| B | H | A115 | 1 |
Table 2
| Part number | Serial Number | Purchase Order |
| A | X | 1001 |
| A | Y | 1002 |
| A | Z | 1003 |
| B | J | 1004 |
| B | K | 1005 |
| B | H | 1006 |
Desired Output:
| Part number | Serial Number | Lot no | Quantity | Purchase Order |
| A | X | A110 | 1 | 1001 |
| A | Y | A111 | 2 | 1002 |
| A | Z | A112 | 2 | 1003 |
| B | J | A113 | 1 | 1004 |
| B | K | A114 | 1 | 1005 |
| B | H | A115 | 1 | 1006 |
Thank you
Hi shamilka,
You can use the Merge Queries option from the ribon. In the dialog that appears hold down the CTRL key as you select the matching column pairs in both tables. Note that there is a small idenification number visible this needs to correstpond for each pair that belongs together (see blue arrow).
I hope this is helpful
1 Reply
Hi shamilka,
You can use the Merge Queries option from the ribon. In the dialog that appears hold down the CTRL key as you select the matching column pairs in both tables. Note that there is a small idenification number visible this needs to correstpond for each pair that belongs together (see blue arrow).
I hope this is helpful