Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ERROR CONSOLIDATE MULTIPLE EXCEL FILES

Good afternoon, I am looking to consolidate multiple excel files in a single query, the files have the same structure, the same column names and even the same location, but how can you see in the tra...
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

Hi Anonymous, 

 

In the row you have selected in the screenshot, it seems to saying that it can't find reference to a column named Column622.

Maybe try visually comparing this file to one that does not error.

It looks like some of your files have different column names.

 

Kim