Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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