Hello everyone, Im having trouble trying to consolidate various excel files into one table.
Im doing the loop start and loop end to read the files, but some excel files have the columns shifted.
Is there a way to look for exact column names every time the excel reader goes through a loop? The actual “Select Columns and Rows to Read” doesnt work for this.
but do you get error or consolidation isn’t right? To my knowledge in such cases (different sheet structure) Loop End node should match by column name and concatenate everything properly (although you might see error in Console: “DataSpec generated by configure does not match spec after execution.”). There is also option in Loop End to Allow changing table specification.