Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Different Schema erro in using Dynamic Input

Highlighted
Meteor

Dear,

 

By the way, I've manually maintained input excel, to make their file name & tab name same, like Excel 1-Sheet 1.

But it still run error, saying that it has different schema than first one.

Thus i think the problem may not be the name of the excel and tab,

FYI

 

Best regards,

Laky

Highlighted
Quasar
Quasar

Have you tried Wildcard XLSX Input macro in the CReW Macro Pack at http://www.chaosreignswithin.com/p/macros.html

 

If one schema is different is will come out the other output of the tool.

Highlighted
Alteryx
Alteryx

Hi @Laky 

 

This article will show you a step by step guide to read in your data. The key here is that in the interface designer (view>>interface designer) you can go to the wrench Icon and change the output mode to 'auto config on name'. This will allow different fields to carry through without it erroring as you have been experiencing. 

 

I would just download the sample module at the bottom of that article and change the directory tool to your dataset. 

 

I have attached the batch macro which will replace your dynamic input currently. You will feed in the full path into this tool. 

 

Alternatively you can use @Joe_Mako approach below. 

 

Best,

 

Jordan

Highlighted
Bolide

Probably to late in the game to be useful to you but may help others who find this thread.  the error you are getting on inconsistent schema can come from multiple sources.  Jordan at Alteryx gave great assistance in regard to issues relating to sheet name variances.  another source that can be independent of file type, xlsx, csv, yxdb, is the actual field definitions.  In excel in particular assumptions are made by excel as to the data types and lengths assigned and Alteryx generally accepts those assignments so if one file was assigned a number data type due to the type of data it contained in that file yet another file assigned the same field as string due to alphanumeric data being present in that column of that specific file then you have inconsistent schema's.

 

This can also throw you off when you read a file of parameters into a Dynamic Input and use String Replacement in the SQL.  If the length of the string changes in one of the variables used as a source for the string value then it will cause an inconsistent schema error also.  In this scenario Alteryx apparently needs the input string to be the exact same size in each case.  I used a formula to pad the string with blanks to get around this.

 

So it may be that the file names may vary due to "Tab" names for excel based files but for any file it may be the perceived data types coming into the Dynamic Input changed from one file to another or finally if using SQL string Replacement the variable values must have the same length.

 

Hope this is useful

Highlighted
Meteor
Spent hours trying to get my head around that. I'll try your workaround. Thanks
Alteryx Certified Partner

fharper above gives a good explanation about the cause of "different schema" error. 

 

For solution, I've written a blog about creating a batch macro to solve this: https://www.concentra.co.uk/blog/how-import-multiple-excel-sheets-and-files-different-schemas-altery...

You can download the batch macro from the link at the end, and check the last part of the blog or the example workflow for how to use it.

Hope it helps.

Highlighted
Atom

The tools are blank when I download 

Highlighted

Hi @Joe_Mako

Thanks a ton.

This really helped me save a lot of effort while automating.

Labels