Excel Reader file name

[Schmali93]

Hi together,

thank you all for your support.

I’ve solved it as descirbed here:

Can knime help me input words in excel automatically

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 c…

Best regards,

Andreas