In this excel file ,The column (Current H8,New H8, Delivery Location)should not be empty, If this following column are empty, In status it should update as Unsuccessful & Remarks are Column name (Current H8,New H8, Delivery Location)not found.
Also New H8 <> Current H8, In status is Unsuccessful & Remarks as New H8 & Current H8 are same.
Finally, I need to add the values to queue where Status <> Unsuccessful.
Since, there are more than 15K rows, I need to process without using loop,
Excel, for your reference
Your request of not using loops for performance reasons is not correct. Please read this thread to know more about the two approaches: standard loops (which in the backend probably already use linq) vs. standalone linq query in UiPath.
As per the approach you can use.
You can use a for loop or nested loops and build up all the logic to find where the edits need to be made and when an index matches those conditions, update the status column with the required string and later write it to excel.
For me its running fine, unable to reproduce your error. Can you please check file path and Non Execute query activity connection properties to ensure everything is in place.
Just use a For Each loop. They aren’t slower than what you’re trying to do. It’s impossible not to loop, all you’re really doing here is trying to hide that it’s looping. 15k records is nothing. I did tests and had to get to 5 million rows before any noticeable processing time difference appeared.