Combining Multiple Excel Files

I found a video on making

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

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

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

I should add it is an iteration column with all zeros

1 Like

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