Schema error during merging Excel with same headers

[AnkitDwivedi6]

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

[djaipras]

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

1. SAMPLE to pull in the first row (n = 1)
2. TRANSPOSE  to get columns names (Name column)
3. REMOVE duplicates on the Name column
4. 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 · Accepted solution]

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-Fi...

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-Exc...