I’m quite new using Knime,
I was using SPSS Clem in the past.
I just would like to know how to aggregate xls files that have the same column structure.
I just would like to create a table with all data (rows) form my all xls files
Maybe you could take a look at this example and modify it. Here Excel Files get imported and the Loop End node collects the results. Also part of the file name gets stored (you might leave that part out).
Maybe you could explain what you want to achieve. The mentioned example loops thru existing excel files that have the same structure (columns) and appends them ‘vertically’ (the Loop End Node does that). you then have the values from (in this case) both excel files in one table in the same columns. If you want to so something else you might have to rename columns.
Maybe you could post an example of what you want to do so we could better understand it.