Loading multiple xlsx files

Hello,
i am new here. I want to load multiple .xlsx files and save the data in one table. Every file have 3 rows, and output file shuld merging by rows.

Hi @k0sa and welcome to the KNIME community forum,

You can use a List Files node and pass the URLs to a Table Row To Variable Loop Start so you can read the files using an Excel Reader (XLS) node and after closing the loop by using a Loop End node, you have all the data inside a single table.

Here is an example:
read_multiple_excel.knwf (36.9 KB)

:blush:

1 Like

You can always add multiple xlsx reader nodes and then use the concatenate node or the joiner node to join these files, in any fashion you wish.

1 Like

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