Filling Missinga Values in a loop

I realised a [Missing Value] node inside a loop (eg. [Group Loop]) is slowing down the processing speed.

Any tips on increasing the speed?
I am trying to loop through each Stock ID and replace missing values with the next values.

Any help is appreciated.

Hi @bentheknimeuser,

What exactly do mean by “slowing down”? Slower than without the node or that the Missing Value node is slower inside a loop than outside a loop?

Best,
Stefan

Hi Stefan, thank you for your reply and apologies for not being clear.
I meant that the Missing Value node is slower inside a loop.
I am using a Group Loop for 70,000 unique item code and I am using the Missing Value to fill up missing information for certain rows.
On average, it is taking 1 second per loop.

I am just wondering if there is a better/more efficient way to do this.

Any help would be appreciated.

Hi there @bentheknimeuser,

I guess the parallel version of Group Loop node would help. Luckily there is a workaround provided in this topic.

Additionally if you are maybe using option Use disk based statistics in Missing Value node turn it off as it is slowing execution :wink:

Br,
Ivan

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.