Comparing Two excel to get a Particular value and send mail

Help Studio
1

I have two excel like Branch Master and Ageing Report. I need to compare both the files using the column name Branch code in both the excel, if the branch code in Branch Master excel is equal to branch code in Ageing Report, i need to get Branch name and email id from Branch Master excel and also i need to send the corresponding data from the Ageing Report to retrieved mail id from the Branch Master.

2

@Monica_K69

It’s better if you can share some sample files of the Input and expected output

At a high-level I can tell you that you can use the Lookup Datatable activity to get the particular value

Thanks

3

New Microsoft Excel Worksheet.xlsx (12.3 KB)
I have attached some sample data.