how to create email seperate notification from two excel table have common column

[kritikamish99]

Dear all,

I have two table 
Table 1 :

Employee name	Manager name
A	ABC
B	BCD
C	CDE
D	CDE
E	HIJ
F	EFG
G	HIJ

Table 2 :

Employee name	Manager name
A	ABC
B	BCD
D	CDE
G	HIJ
F	EFG

In the above case Manager name "CDE" and "HIJ" does not have employee "C" and "E" from table 1. So i need to create emails notification where i can write mail to manager "CDE" and "HIJ" stating your employee "C" and "E" has left the organisation kindly delete the data from backend . The mail to manager will be sent individually with their Employee name in mail body .

[Raj · Accepted solution]

@kritikamish99 
find the workflow attached
mark done if solved.

[kritikamish99]

This will not send Indvidual mail separately right to manager at time 

[Raj · Accepted solution]

@kritikamish99 
add the email ID for the managers and this will send individual emails.

[kritikamish99]

Hi @Raj ,
Actually i have got another issue .
The tables are as it is. but in the both tables email id is not present . and this table are saved in mysql database.
. 
So possibly i need to add email text "@companymail.com" something like ABD@companymail.com.
I thought to take up office365user data into alteryx but that is not possible i guess. Is there a way to do to add the column in table one with @company.com and then concatenate into 4th column of table 1.

Table 1 :

Employee name	Manager name
A	ABC
B	BCD
C	CDE
D	CDE
E	HIJ
F	EFG
G	HIJ

Table 2 :

Employee name	Manager name
A	ABC
B	BCD
D	CDE
G	HIJ
F	EFG