Forum Discussion
Merge two table on two columns with OR operator
Looking to merge two table on two columns A and B. However, I want to do the following: Try to match on column A and ONLY IF column A is empty, try to find a match in column B. What I have now: ...
I think your answer might be in your question.
Give the Try and Catch a crack?
1. Goodly - Youtube - Try and Catch in Power Query | Smarter way to work with errors in Power Query
2. Error handling - Power Query | Microsoft Docs
Disclaimer: I'm a novice and learning