Table.NestedJoin if Statement

[jilbobagins]

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

 

[Ron Coderre]

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.

 

[jilbobagins]

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...

 

[Bob Phillips]

Can you post a workbook so we can see the data?

 

[jilbobagins]

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!