this is my first post here. Hello first of all together!
we have a file that we receive daily that contains stock levels of items. Unfortunately, there is no date noted in the file.
This is in the file name. Now we would like to set for each entry, the date to be able to write it to a database.
However, only the first entry is always provided with the date. (We have already solved the formatting of the date from the file name)
I think we need a loop or something similar. But then how do we always address the next item and also know when it ends.
We currently have over 800 files with increasingly larger content.
Can you share the workflow JSON and the file you are using or maybe just the first 5 lines. With data looping n8n will automatically loop the results for most nodes so you don’t need to but if you wanted to make a manual loop you can use the Split in Batches node.