Table.NestedJoin if Statement

jilbobagins

jilbobagins

Member
Joined
Apr 11, 2019
Messages
80
Reaction score
0
Points
6
Excel Version(s)
2016
Howdi,

Does anyone know if its possible to Merge 2 Tables together where the first table has two possible columns to join from and the second table only has one??

Would an IF statement be potentially be used in this scenario?

Thanks
 
Sounds like you'd need to do two merges. One, joining on the first column and a second joining on the second column. Then append the two results and remove duplicates.
 
Yes I could, I'm struggling with the performance of this query and trying to get the desired result with a few steps as possible...
 
Can you post a workbook so we can see the data?
 
Unfortunately I can't as its a full of IP. The biggest thing with most of the queries now (certainly on more complex tasks) is making the things run quickly!
 
You must log in or register to reply here.
Back
Top