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 

[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/t...

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.

Hope this helps,

M.

[atcodedog05]

Awesome @mceleavey  😎

[Abhii2658]

@mceleavey can you guide me how to get the configuration going ? I am trying the Dynamic multi file sheet names 

In the macro file input - i give the file name and then what ?

I have 16 total files that i plan to import with FileName_*.XSLX

[Abhii2658]

@atcodedog05 if you could help as well. 

[mceleavey]

Hi @Abhii2658 ,

the first file is the entire thing built for you, you simply need to point it to the folder, input your naming convention and away you go.

The first macro tool will return all available sheets so you can filter out the ones you don't want.

Can you show me where you're having a problem?

It should look like this:

M.

[Abhii2658]

@mceleavey where do i connect my input file ?

[mceleavey]

@Abhii2658 ,

you're in the wrong place.

Open the package that was attached. The .yxzp file. This is the workflow and will automatically install the required macros. (I've attached it again)

It should look like this:

M.

[Abhii2658]

I have update my Alteryx.