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)
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.