Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello ,
I have two table
1. Employee detail
Manager Email | Manager Name | Employee Name | Employee Email |
S.S@gmail.com | SS | Abei | Abei@gmail.com |
S.S@gmail.com | SS | beia | beia@gmail.com |
2. Task Detail
Employee Name | Employee Email | Manager Name | Manager Email | Task | description | |
Abei | Abei@gmail.com | SS | S.S@gmail.com | xyz | abc |
I want to have a column that joins both the column and the result should be
Employee Name | Employee Email | Manager Name | Manager Email | Task | description |
Abei | Abei@gmail.com | SS | S.S@gmail.com | xyz | abc |
Beia | beia@gmail.com | SS | S.S@gmail.com | null | null |
I tried doing left join but i am not getting the desired result it is showing as
Employee Name | Employee Email | Manager Name | Manager Email | Task | description |
Abei | Abei@gmail.com | SS | S.S@gmail.com | xyz | abc |
Beia | beia@gmail.com | SS | S.S@gmail.com | xyz | abc |
Solved! Go to Solution.
Hi @sonalisaha2310 ,
After my test, I guess you are using Manager Email or Manager Name as the matching columns, this does cause the wrong results you are facing:
Please try to use Employee Email as the matching column:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You should join based on Employee name and Employee email.
Hi,
You should join based on Employee name and Employee email.
Hi @sonalisaha2310 ,
After my test, I guess you are using Manager Email or Manager Name as the matching columns, this does cause the wrong results you are facing:
Please try to use Employee Email as the matching column:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A left join should work if you are using the Employee name to join the two tables.
Hi,
Are you doing a merge using left join in power query? if so what is your left table among those two and on what column basis you joined?
@sonalisaha2310 ,Instead of left join try using full outer join
Proud to be a Super User!
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |