Select Multiple files from Folder

[saiakula15]

Hi Team,

I would like to know how we can read multiple files from a folder through KNIME server.
For reading one single file we can use File Upload Widget, but i would like to ready multiple files from a folder. could you please help me what i can do in this case.

Thank you,
Sai Akula.

[saiakula15]

Also i would like to read all the Tabs present in the excel sheet. for this we will be using Read Excel sheet name. I would like to know a Node or process with which we can read all the Excel sheets present in the Folder while the path should be selected from Knime WebPortal and execute them.

Thank you,
Sai A.

[thor_landstrom]

Hey @saiakula15,

For your first question –
So as of now, the devs are working on a enhancement to allow multiple files to upload. The only work around is to compress your files to a zip and then use the ‘Decompress Files’ node to unzip it and now you have your multiple files uploaded!

Here is a snippet of one of the workflows I have been working on that uses this workaround to give you a place to start:

Now for the second question:
I had to do what you needed with upload multiple excel files in a zip, then looping through each of these files and each of their sheets. To do this you just need 2 loops. One loop for iterating through the files, and another nested loop for iterating through the sheets. You can see how I do it in the image above by using the first loop to go through the files, then I read the sheet names, and I run a loop on each of the sheets:

Hope this helps,
TL

[saiakula15]

Hi @thor_landstrom,

Thank you for your reply.
I have to select files from through Knime Webportal, Can you please let me know if we will be able to select the files from file webserver. Also will it be possible for you to attach the workflow so that i can go it and understand it better.

Thank You,
Sai A.

[thor_landstrom]

Hey @saiakula15,

Yes you will be able to use it on a web app/web portal. I put a file upload widget node for that purpose, and also a file download widget for when its done.

Here is the workflow on my community hub space:

https://hub.knime.com/-/spaces/-/~zgRKeICZmfQ3UMRX/current-state/

TL