Forum Discussion
Helper IIJoin with an OR condition?
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?
2 Replies
- amitchandak
Super User
thisisausername , create two tables with these joins and append
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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.
