I am trying to Lookup a value found in Excel in another Excel.
This are the 2 Excels:
The First(Email_Report.xlsx);
The Second(1287_IME_AUDIT_FILE_GENERATION_20220824.xlsx):
If the file name in the input_extern_file_name column of the first Excel, Email_Report.xlsx is found, the I would update the Status column with the value found in acquisition_sys column of the Second Excel(1287_IME_AUDIT_FILE_GENERATION_20220824.xlsx)
I have constructed this process using UiPath Activities Attached is the Screenshot of the process and the process itself:
The Problem is that it takes a very long time.
I wonder if a human needs to take this long to complete a similar task.
And so I used a Linq Query approach hoping that it would cutdown on processing time. Below is the Screenshot of that process
Attached is my LINQ Statement used in the Assign Activity:
Ori_dt.AsEnumerable().Where(Function(row) Reference_dt.AsEnumerable.Any(Function(x) x("input_extern_file_name").ToString=row("input_extern_file_name").ToString)).CopyToDatatable
This too took a very long time. Can someone help me to fine tune the above LINQ. If there isn’t any other way to speed it up, can someone assist me in finding out a much faster way to lookup values in two Excels using UiPath.
Thank you.