Combining Multiple Excel Files

KNIME Analytics Platform
#1

I found a video on making

multipleexcel
multipleexcel1920×1080 315 KB

I ran this work flow but the problem is that it is not only combining the data but is also copying my headings each time I loop in a new spreadsheet.
How can I keep it from adding the headings 5 times and only copying the heading once on my spreadsheet.
Thanks
Scott

#2

Assuming each sheet has exactly the same headers, you need to selection the option to recognize column headers in the Excel Reader node.

1 Like
#3

Thank You
I have it working but I noticed two things.

  1. The Read Excel Sheet Name when I check the output table it shows ROWID and $Sheets
    Row0 Sites
    Shouldn’t it list my 5 files names there?

  2. I notice it is creating a new column and adding a 0 for each row. Is there a way to have it not do that?

Thanks
Scott

#4

I should add it is an iteration column with all zeros

1 Like
#5

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