Schema error during merging Excel with same headers

Hello, I have got an error while merging two different excels with same header. Could any one let me know how to fix this.

"Start: Designer x64: Started running at 12/18/2020 00:13:13
Warning: Input Data (1): The file "userdata\Desktop\File_2.xlsx|||`Sheet$`" has a different schema than the 1st file in the set and will be skipped
End: Designer x64: Finished running in 3.3 seconds with 1 warning

Common Use Cases

Accepted answers

AngelosPachis

Hi @AnkitDwivedi6 ,

The files should have the same schema, so same sheet names, field names, field types and field sequence. To overcome that you can create a batch macro and you can follow the steps of the following post:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/tac-p/470288

There are many other posts in the community that can help you to do that.

Hope that helps, reach out if you have any questions.

Regards,

Angelos

EDIT : Also found this great post on LinkedIn https://www.linkedin.com/pulse/how-import-multiple-excel-sheets-files-different-schema-bingqian-gao/

All comments

djaipras

It could be that the names might not be the same. Here is one method to check:

SAMPLE to pull in the first row (n = 1)
TRANSPOSE to get columns names (Name column)
REMOVE duplicates on the Name column
JOIN the two sets on the Name column (The stuff in the L and R of the joins will be what is not the same)

If you could add a sample of what the files are like, it would help.

AngelosPachis

Hi @AnkitDwivedi6 ,

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/tac-p/470288

There are many other posts in the community that can help you to do that.

Hope that helps, reach out if you have any questions.

Regards,

Angelos

EDIT : Also found this great post on LinkedIn https://www.linkedin.com/pulse/how-import-multiple-excel-sheets-files-different-schema-bingqian-gao/

BrandonB

This is a fantastic macro for reading in a directory of files even if they don't have the same schema: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703