A question: I am currently running a three stage process in workfusion to reconcile reports. Basically it can be broken down into 3 steps:
- \Extract information from 2 excel reports
- run a for each loop that executes a bunch of rules to modify the reports into usable data
- read the report into a separate excel file.
Currently the solution works 100% but what I have realized is as soon as the for each loop on step 2 runs past more or less 260 rows in excel all of the sudden instead of taking 0.3 seconds to go through a loop all of a sudden it takes 10 seconds, and it just deteriorates from there. Is this a memory issue?