I have issues all the time with loop…
I reading data from databases and pair the data with other database.
Its like 1500 posts in each database and I need to pair each post in the first database.
So I can do a merge with all posts, it will be more than 2 million items = crash.
So I wanna do one post at the time, but the loop only do one at the time and stops workflow.
all kinds of models cant help me… they say I dont need the loop… so im stuck.
Any help?
1.90.2
Noco
When using the loop over items node you need to return to the loop node at the end of the process. Then it will start the processing of the next item(s) in the list.
Do keep in mind that if you do this with lots of items in one workflow you will still run into issues.
Easiest is to put everything from within the loop in a sub workflow that you execute with the execute workflow node.
Dont forget to clear the data at the end of the subflow so it doesnt return the data into the main workflow. (it will return the data of the last executed workflow.)
Thanks! How do I clear the data?
You can use a set node where you tell it to keep only the set fields and set that to run only once. Of course without setting any fields.
Or put in a code node with this code: return [{json:{}}]
