Need a help to optimise time of comparsion.
I need to compare csv and xls file, i’ve used for each row activity in another for each activity and if block:
if “rowname” from xls file = “rowname” from csv file
and sum (“rowname” from xls file + “rowname” from csv file) <> 0.
Result of this condition is a new xls file.
Its working to long, about 2 mins.
I dont understand how to read files to arrays for further comparsion, i think in arrays it will be much faster.
I`m newby in UiPath, sorry for dum question.
i’ve tried to load xls to data table using for each activity, but it still to long.
Maybe i dont understand how to load data to data table.
Can you please add xaml file where you load xls or csv to data table?
Thanks, but I’ve already saw that tutorial.
My xaml already working, but too long.
I’ve reading two files into dt, than comparing two data tables using for each row activity in another for each. I need next result:
If account in file 1 = account in file 2 and sum in file 1 + sum in file 2 <> 0, output all matching results to xls file.