How to read all files in one folder automatically

[HKuser]

I have several files in the folder (about 20 excel files)
Here is the flow that I created.
However, I found that it keeps to loop one file for 20 times. (Same set of data appears 20 times)

Where is my question

[ipazin]

Hi there @HKuser,

I guess you haven’t properly configured to use flow variable holding file name in Excel Reader node. Check this example from Hub:

Read an XLS file – knime

But you can read multiple Excel files without loop. See here:

Help - Loop // Add Column

Hi there @Andy1981, welcome to KNIME Community! Just to add that with new Excel Reader node (available from KNIME version 4.1.0.) you can read/import multiple files without using loop! Choose Files in folder option and specify folder [ExcelMultipleFiles] Doesn’t have option to add file name into new column but considering it is pretty frequent and reasonable request when consolidating data have added feature request for it (internal reference: AP-13949). Edit: See here for adding fi…

Br,
Ivan

[HKuser]

I still cannot fix it using ur way

[scapuzzi]

Hi @HKuser:

@ipazin gave you the right answer. You need to configure your flow variable in the node.

Since your flow variable file path isn’t set in the node, you are just looping over the same file that you added in the “XLS Reader Settings”

Click the “flow variables” tab in the node and set the flow variable path. See the screenshot:

[HKuser]

why mine is not the same as yours?

[trj]

@HKuser,

Don’t you have the following option next to the URL ?

1. Click on the V
2. Select your variable (URL)

[HKuser]

Yes , so i changed. But still cannot finish

[trj]

You have to set the Variable OR the Flow variable.
As well, the SHEET_NAME is not the URL.

Can you send your workflow without reseting all the nodes ?

And can you do a print screen of the output of the List Files ?

[HKuser]

I finally fix the problem! Many Thanks!