I am trying to update 450 rows in an excel file (4 to 5 hundred thousand records).
all rows in the excel file are unique.
it is taking a lot of time to update the excel file. even after updating the row it is checking all the records to update thinking there are other rows as well to update...
combine all data in one collection or an excel sheet and remove duplicated value and add that data to queue(as best practice) instead of using data from excel.
To remove duplicates in collection there is an action in utility collection manipulation - remove duplicates. pass the collection...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.