How to get the employee name with no value in the table

[sonalisaha2310]

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

[v-junyant-msft · Accepted 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.

[Ashish_Mathur · Accepted solution]

Hi,

You should join based on Employee name and Employee email.

[v-junyant-msft · Accepted 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.

[Bmejia]

A left join should work if you are using the Employee name to join the two tables.

[AnushaSri]

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?

[bhanu_gautam]

@sonalisaha2310 ,Instead of left join try using full outer join