I keep getting the following error when reading a half dozen small Excel workbooks using a Data Input tool set to read *.xlsx from a specific folder. I have checked the Excel worksheets for format differences (header/footer, column headers, hidden columns, etc) and cannot find what is different if anything. I have even entered the scores from one survey response worksheet to the one that works and renamed/saved - still to no avail. I'm am definitely pulling my hair out over this one.
Anyone seen something weird like this occur before? Thoughts about how to troubleshoot? I have to process a fairly large number of worksheets in te next day or so. Open to any and all ideas... Thanks.
Warning: Input Data (1): The file "C:\Users\dennispuls\Desktop\Working Documents\XXX\CapMat Survey\XX Cap Mat Responses\R2 - 03.21.2019 - XX IT Capability Maturity Survey_XXX|||`Survey$`" has a different schema than the 1st file in the set and will be skipped
