How to match Employee Name and Project Code in a daily report and e-mail relevant data to him

Help Activities
, ,
1

Hi,
I have Daily Report get generated and Project Code varies and want to map the relevant employee Name and e-mail address to send that particular information (Sample Output) daily to relevant e-mail address.
Please refer to attached sheet.
thanks for your help in advance.
Demo.xlsx (19.2 KB)

2

@Sudhir_P

You can use Read Range activity to read the excel sheet and pass below for reading the particular sheet

image

image

It will change dynamically according the current date

Declare a variable let’s say it’s a Dt1

Now use Read Range activity and declare a variable let’s say Dt2

image

Now use Join Datatables activity using Department Code as it’s common for both sheets

image

Now you can use Filter Datatable and output your required columns

You can use Write Range activity to write back to excel

Hope this will help you

Thanks