Your files are not formatted same. In one iteration your column 1 is NASC and in other it is BASC
Change your files or enable option “Allow changing table specifications” in your Loop End node configuration window but I guess you want to change your files to all have same column names if meaning is the same.
Well now I am slightly thrown off – I know the column beaders are different in each file, that is on purpose. What I want to do is combine all the files into one sheet. So the leftmost column has the same data (codes) the second column, in this case NASC or BASC, has different data. So I want to combine the data into one table, keying the leftmost column.
I know there are other ways of doing this, such as a joiner, I just wnated to try and do it using a loop for when the file directory gets to be much larger.
Not quite sure what are you trying to accomplish. Excel Reader in a Loop together with Loop End is intended when you have same file structure and you want to append/concatenate rows from each file. You can enable option “Allow changing table specifications” in your Loop End node configuration window and then you will get all column in your data set regardless of their names. Also you can try different ending to a loop. Loop End (Column Append) node will have same/similar effect depending on your data.