Hi, I have a couple of Excel files where I have to read range (rows may go up to 10k). From those datatables, I have to count rows that fulfill specific criteria for different entities.
I now have a do while to loop for each entity.
Would like to ask which option is much more feasible in terms of avoiding system out of memory exception
Option 1: Place “For Each Excel File - Read Range” inside Do While loop, so always having only 1 datatable, but may have to read same datatable a couple times.
Option 2: Place “For Each Excel File - Read Range” outside Do While loop, so always remembering a few datatables at the same time, but does not have to read for each entities.
Attach workflow belowAML_Excel_UpdateDashboard.xaml (52.9 KB)