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)
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.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.