Good Day Everyone I have an issue merging multiple files in excel, Alteryx throws an exception that there is a mismatch between files and skips importing it. Here is the summary File 1: Field NameTypeField 1 V_StringField 2 V_StringField 3 V_StringField 4 V_WString File 2: Field NameTypeField 1 V_WStringField 2 V_StringField 3 V_StringField 4 V_WString File 3: Field NameTypeField 1 V_StringField 2 V_StringField 3 V_StringField 4 V_String Thanks

@Abhii2658 , save the two .yxmc files to your macro folder, then open the .yxmd file. That should work. M Multi Sheet Import Example 2.yxmd Dynamic Multi File Sheet Names.yxmc Import Multiple Schema Flat Files.yxmc

Schema mismatch issues - Multiple excel file not being merged

Abhii2658

Good Day Everyone

I have an issue merging multiple files in excel, Alteryx throws an exception that there is a mismatch between files and skips importing it.

Here is the summary

File 1:

Field Name	Type
Field 1	V_String
Field 2	V_String
Field 3	V_String
Field 4	V_WString

File 2:

Field Name	Type
Field 1	V_WString
Field 2	V_String
Field 3	V_String
Field 4	V_WString

File 3:

Field Name	Type
Field 1	V_String
Field 2	V_String
Field 3	V_String
Field 4	V_String

Thanks

Data Investigation

Accepted answers

All comments

atcodedog05

Hi @Abhii2658

3rd option from this post might be helpful

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Hope this helps : )

mceleavey

Hi @Abhii2658 ,

I've built some tools to do exactly this.

I've attached the tools and an example workflow.

Basically, the first tool loads in the names of all tabs within the spreadsheet, creates a full path including the tab names, then loads them all in according to the schema of themselves, so you will never get that error.