Can someone explain how to do lookup from one excel to another excel

Help Something Else
1

hi there, I have attendance data of 2 employees in one excel sheet. I have another excel sheet but the employee names are interchanged. I want to ensure that the attendance data is pasted against corresponding employee names. I tried using ‘Lookup data table’ activity but it is not working. can someone help to resolve this issue. Thanks in advance.

2

@madhav_ravi

Please refer the below attached xaml file it might help you.
sample.xaml (67.3 KB)
test (2).xlsx (10.4 KB)

Hope it works!!

1 Like
3

@madhav_ravi

You can just loop through the first excel and then use filter datatable inside the loop to filter the second table based on name you get from first table so basically filter will be on name with currentrow("Name").ToString

Cheers

1 Like
4

Hi varun, thanks a lot for your timely response. your solution is working perfectly. You are an expert in UiPath…Keep rocking…

5

@madhav_ravi

Thank You

Happy Automation!!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.