Different schema than the 1st file error

HI All,

I am trying to combine a number of workbooks, all of which have tabs titled the same.

I tried to create a workflow with input data for each of the tabs and with the use of "*" to pull automatically from a folder as and when more files come into it.

However I am getting an error which says that one of the tabs from one of the worksheets has a different schema than the 1st file

I think i need to use a batch macro but I am not sure how. Any suggestions how to solve this issue?

Thanks

Error Message

Accepted answers

mceleavey

Hi @seelan89 ,

Use the directory tool in conjunction with the attached macro. This will loop through and load in each sheet at a time. This is very useful as it circumvents a problem you often encounter with the standard Directory input with the Dynamic Input tool, where things such as merged cells in Excel often cause problems.

I hope this helps.

Import Multiple Schema xlsx.yxmc

All comments

MichalM

@seelan89

Here's a great article explaining how to approach this problem.

mceleavey

Hi @seelan89 ,

I hope this helps.

Import Multiple Schema xlsx.yxmc

seelan89

@mceleavey @MichalM thanks both.

sample workflow helped a bunch as well.

JokeFun

I am a beginner here. I could not understand this macro and have no idea on how to run this. Would you please elaborate?

For me, I do have a problem with Read all input files. It goes well for all the files from 1Jan to 8Jan, but showed error for 9Jan saying it has a different schema than the 1st file in the set.

dawnh80

Great solution! I had a user run into an issue this week and found your workflow helpful!

MichalM

There's no need to configure the Group by tab to make the macro work. You can turn it back to the default value.

rjasred

Hello team,

the directory tool will not work on Server. any other suggestions?

Thanks & Regards,
Rajasekhar Reddy A

dsandmann

@rjasred Does directory tool not work on server or does it require UNC pathing? Depending on the server set up you may need to use the full path ex. \\DRIVE\example\folder\ instead of your mapped location of X:\

JamesG21

The macros work well, well not the "flat" version. Is there an option to start the data from a different row other than 1? I manually updated the macro to start the data on Row, but wanted to know if there was an option to add a question for this.

CASaiRam

Hi. I faced this error recently. I was trying to combine three files containing 23 columns. But the cause of error is that in one of the files the 23rd column is having some values, but in the other two files the 23rd column is completely empty. Once i was able to observe this and remove the 23rd column it was working smooth. My understanding is like as the 23rd column was completely empty alteryx might assume that there were 22 columns in the other two files and 23 columns in the first file.

So alteryx at sometimes can get confused and confuse us as well

dsandmann

You can actually use a batch macro to get around this - if the columns are all the same just use the batch to swap file names on an input data tool, and then convert all the columns to string. You can correct the data types from outside of the macro output.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335