Iterate takes a long time

1

Hi

I would like to transform the following dataset

image

to this

image

I have 10,000 records and it takes more than 30 minutes.

Are there a better way to do it?

BetweendatesUpdate_V0.morph (8.9 KB) Start.xlsx (28.2 KB)

Thanks

2

The cause of slow execution is the project reads the same Excel file in each iteration, i.e. 10,000 times. Instead, you can read the file once, and pass it in each iteration. EasyMorph has the “Iterate table” action exactly for this case.

Here is the updated project:
BetweendatesUpdate_V1.morph (8.9 KB) .

Also, I’ve changed how the main dataset filtering is done in the iterated module. Instead of filtering by condition, I’ve used “Keep matching” because it’s faster.

2 Likes
3

Excellent

Thanks, Dmitry
It took 1min 20 sec to run compared to 30min before!
:grinning:

4

You’re welcome :slight_smile:

1 Like