Reading Listed Files

Let's say we have exactly the same format files. We want to read these files together. We can give an example where sales data for each month is kept in separate files.

How do we automatically read and assemble these files with Knime?

I have 3 excel files in the loop folder.

All of these files have the same columns.

We want to collect this information belonging to 9 people.

First of all, we display the List Files node. This node lists the files it can read in a particular folder.

We select the folder where the files are located by clicking Browse from the Configure screen.

Our second step is to add the Table Row To Variable Loop Start node. This node will detect the files as variables and determine the data that will return in our loop. There is no need for any setting.

Now we can read excel files. But the previous node has a red output with variable output. No input connection to XLS Reader node. To make the connection, right-click XLS Reader and click Show Variable Ports. We connect the previous node with the red dot on the corner of the node.

We choose one of the files we will read in XLS Reader and set how Knime will read these files.

Finally, we add the Loop node.

Our Workflow was created as follows.

When we run it, we will see that all our files are together.