Read all files in KNIME 4.4.2 in a loop

KNIME Analytics Platform
1

Hi.
I want to read all files in a loop but specific sheets among them. Moreover I want to have file path with me. I could do this in earlier KNIME version but now those nodes are depreciated. Can anyone help me to make this flow using all new nodes?

  1. Read all files in a folder
  2. Then read specific sheet
  3. Append all files together
  4. Have the sheet name and file location as separate column

Again I could do this in earlier version but having some issues in newer nodes. I am attaching both new and old flow as well. Thanks!

image
image886×407 41.8 KB

Loop read.knwf (39.0 KB)

2

@jamalbutt1232 you could still use the loops to import Excel files.

Maybe this example with the new path variables might help as a start:

5 Likes
3

I will try to use it. Thank you! But have you developed such flow yet the one I mentioned with specifications? I wanted to have a working example with me

4

Hello @jamalbutt1232
I prepared this workflow for a different topic earlier this month, but some of the bullets that you mention are covered.

You will have to deal with desired SheetNames to feed the variable as that bullet one is not covered. But the process is similar: Sheet Name to variable and Constan Value Column…

BR

3 Likes
5

Hello @jamalbutt1232,

it does take a bit to transition from old to new file handling so if you share 2 Excel files (delete real data and add couple of dummy rows) I (or someone else) can take a look and tell you what you are not configuring properly :wink:

Br,
Ivan

1 Like
7

Thank you it helped a lot. Got the solution!

3 Likes
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.