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.
Hope it works!!
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
Hi varun, thanks a lot for your timely response. your solution is working perfectly. You are an expert in UiPath…Keep rocking…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.