Read multiple, but different files

Hi KNIME community,

I would like to ask how can I read multiple files using list files+variables? The files I need are different in layout and from different systems than will be reconciled based on certain parameters later on. (Originally it will be more than just 2, but for now I cant even do it with 2)
I already have my full workflow done, but all the starting notes are excel readers looking at the files, which I want to correct to use variables.

This is the idea how it would start, but the second file is not getting read, just the first one.
image

image

In the variable loop start the path only goes for the first in the list.

How can I separate it in the variable settings so that the first reader node imports the first file and the second reader, the second file?

hi @olahkrisz
there are similar question being asked before that look similar to your problem.

  1. read multiple excel files: Read Multiple Excel Files

other results might be helpful:

  1. read multiple excel files in a loop: Read multiple Excel files in a loop
  2. read multiple excel files and extract information: Read multiple excel files and extract information of certain cells

hope this helps,

rgds

4 Likes

Thank you very much marzukim :slight_smile:

1 Like

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