I would’ve used a Chunk Loop Start node to isolate the individual rows of URLs generated by the List Files node.
The Output of this node gets split into 2 branches:
- the 1st branch goes to a Table Row to Variable node which converts the URL into a variable which can then be used to tell an Excel Reader node which file to grab.
- the 2nd branch leads to a Cell Splitter node with an appropriate delimiter such as the forward slash, which allows you to isolate the file name portion of the URL. You can always do more processing to get the format exactly the way you want it.
- You can convert this to a variable and use a Constant Value Column node to append a column to the output of your Excel Reader node in which which each row contains this value.
- A Loop End node concatenates all the data.
The workflow below achieves the same results, but feels a little more clunky to me:
You download both workflows form here and have a look around:
There are probably other ways to achieve this, but these workflows are what came to mind first.