Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone i have 2 tables
IDOrder ID
1 | aaaa-bbbb |
2 | aabb-bbaa |
1 | 123-gvb |
2 | abdf-475 |
2 | gsgsd-4674 |
and table 2
Order IDAmountID
aaaa-bbbb | 486 | 1 |
aaaa-bbbb | 684 | 1 |
aaaa-bbbb | 34531 | 1 |
aabb-bbaa | 44841 | 2 |
aabb-bbaa | 53 | 2 |
aabb-bbaa | 77 | 2 |
aabb-bbaa | 464 | 2 |
aabb-bbaa | 176 | 2 |
when i merge between the wto tables taking id as the key, ordr ID doesnt math and i get multiple rows
when i expand, i get this
i need to add a condition to return order id equal to the main order id which is only aaaa-bbbb for the first 2 examples and not add new rows as yo usee, so match orderid and id
Solved! Go to Solution.
Hi @pbiguru123,
hold CTRL during merge step and select continuously columns ID and then Order ID. It will consider matching on both columns, but to be honest I don't understand why do you want to get Order ID from another table when you have Order ID in this table already.
Result
Hi @pbiguru123,
hold CTRL during merge step and select continuously columns ID and then Order ID. It will consider matching on both columns, but to be honest I don't understand why do you want to get Order ID from another table when you have Order ID in this table already.
Result
i did not know i could do that cheers