Join with an OR condition?

[thisisausername]

I have a Products table with CountryID and Company ID.

I have two separate tables with those keys - Countries and Companies.

I want to in Power Query do a left or inner join in my Products table on where either [CountryID] = Countries[CountryID], OR where [CompanyID] = Companies[CompanyID]

Is this possible, to have this kind of OR condition in a join in Power Query?

[Anonymous]

@thisisausername 

As far I as know, you cannot have multiple join types between 2 columns. Currently, I cannot see any workarounds in my test. My suggest would be use append table instead. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@thisisausername , create two tables with these joins and append

https://radacad.com/append-vs-merge-in-power-bi-and-power-query