Automating the comparison of 2 excel file and storing the result in a 3rd excel file

excel
uiautomation
activities
studio

#1

Hi everybody…
I got this issue where I got to compare 2 excel files of information and compile the result into a 3rd file.
Download the excel file
WorkWorkerSupposetoDo.xlsx: https://ufile.io/ojl8s
ActualWorkDoneByWorker.xlsx: https://ufile.io/cwux0

WorkWorkerSupposetoDo.Xlsx

  • This file contains the workers’ timetable and places he/she suppose to work on

ActualWorkDoneByWorker.Xlsx

  • This file contains the actual work and place that worker has done.

CompilationOfResult.Xlsx
-This file should contain all the address 2 excel file above.

  • This file should contain the result whether the worker has done the work that he supposes to work on compared with the actual work done.

Tricky Part is Address in ActualWorkDoneByWorker.Xlsx and WorkWorkerSupposetoDo.Xlsx do not match exactly
e.g.
2131 Green Hill Road = Green Hill Rd
2916-2916a White Avenue 3 = White Ave 3
2918 White Avenue 5 = White Ave 5 (T-Junction)

May I know how to use uipath to resolve this issue if this is even possible?


#2

Here’s the 3rd file hyperlink to download CompilationOfResult.xlsx: https://ufile.io/prhvk