Log In
Register
Home
Excel Expert
Power Query
April 16, 2016
Offline
Hi, sorry if someone asked and answered this before. But I am building an app to upload 400+ excel files...
When I issued them to individual users, they have been consolidated through PQ which means I know they are all in the same format and correct. But when they are back from the users, errors start popping. Instead of opening up 400+files and look them individually, what's best way to identify the exactly incorrect one.
Thank you
July 16, 2010
Offline
Hi Yifan,
Welcome to our forum!
The troubleshooting approach will depend on the error you're getting. Is there not some type of identifier on each row that tells you what the source of the data was e.g. date, location etc? You could filter the query to only show the errors.
Mynda
Excel Expert
Power Query
April 16, 2016
Offline
Well the first time I did the error I received was with the dataset basically one of the table to be combined and edit missed a letter in the header, I opened each of the 420 spreadsheets, and copy and paste to make it consistent, and now it says one of the file is corrupted. 🙁 How can I quickly identify which file was to fix..Because there are so many of them, so it stop loading once it encounter an error and I can't use the filter to identify the name of the file. 🙁
VIP
Trusted Members
December 7, 2016
Offline
Hello,
One way to do it is to add the files to the folder in batches, for example 30 or 40, then update and if no errors, add next batch and so forth. By this you then know which batch of files to check individually.
Br,
Anders
1 Guest(s)
