Merging Issue, return value based on 2 columns instead of matching 1 column

[pbiguru123]

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 

[dufoq3 · Accepted 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

[pbiguru123]

i did not know i could do that cheers