Forum Discussion
Solved
Is merging queries smart?
I have two datasets that share similar employee data (names etc.), I am merging these datasets on an Employee ID. Some Employee IDs are blank in both datasets, but left joining the datasets seems t...
There are different join kinds for mergeing
Power BI Merge Queries and Append Queries (mssqltips.com)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Thank you for the reply, that is how a typical SQL join would work also. So I am probably seeing the correct match but if I looked further would see the incorrect match (for the other blanks).
