Hi - I am trying to pull in multiple excel files from the same folder (including sub folders). Each of the files have identical schema and the same sheet name, however, when I tried to do this, only 4 out of the 7 files pulled in. I assumed that there must be an issue with the schema in the files, however on checking them, they all seem consistent on initial viewing.
To test this, I exported each of the files and reviewed the columns and there seemed to be some inconsistencies in the formatting of some of the columns, but these were not consistent with the results, for example, the Date column was either text or Date, but I had a mix of files that were successful.
I then took the first row from each of the working files and created some test data and have attached an excel that shows the results.
The only thing I can see is that when I placed a select tool after the 'successful import' and then another when I pulled in the missing files, there was some differences in the column types. Would that be the issue and if so, do you know how I can fix this as these files are automatic and not something that would be controlable. I did try to change the format on the files that didn't pull in, but it did not appear to make any difference to my results.
Hope all this makes sense.
