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 transform file column there are some files that present error. Anyone know how I could fix that issue?

 

 

Need Help

2 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous 

    Agree with KNP , go to your excel files. Compare [column622] column between files, the error could be caused by unmatched column names, data type, etc.

     

     

    Paul Zheng _ Community Support Team