Forum Discussion
Inner Join with custom conditions
Anonymous solution is ok but don't merge in power query, just load both the tables and set relationship between the tables on the columns you are using for join in SQL, but yes, do the replacement in Power Query
Merge is an expensive query and if not required, one should avoid it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
You will need to use power query to accomplish this. You will need to do the following -
1) Import both tables into power query
2) Perform any the "Replace" Transform on table 1.
3) use the "Merge" function in power query to join the tables.
Anonymous solution is ok but don't merge in power query, just load both the tables and set relationship between the tables on the columns you are using for join in SQL, but yes, do the replacement in Power Query
Merge is an expensive query and if not required, one should avoid it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Agreed merge should be avoided. Relating tables is preferred but maybe a bit unintuitive.
Thanks very much
