Forum Discussion
Solved
Merging Queries with OR
Hello, I am attempting to merge to queries together but I need to do so not simply with a TableA.Key1 = TableB.Key1 but instead with TableA.key1 = TableB.Key1 OR TableB.Key2 I have found a wa...
In Power Query you would need to do two merges, one with each. Then keep the valid data you want with an if/then/else statement. You can do a conditional merge based on records as shown here but I think trying to do that with tables would be painfully slow.
In Power Query you would need to do two merges, one with each. Then keep the valid data you want with an if/then/else statement. You can do a conditional merge based on records as shown here but I think trying to do that with tables would be painfully slow.