Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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