Getting Error The file has a different schema than the 1st file in the set

[kiranjoka]

Hi,

I have to run single query multiple time with different tables, I am running query using dynamic input tool

while running the query, I am getting error The file has a different schema than the 1st file in the set

Any one please help me on this.

[DataNath · Accepted solution]

@kiranjoka the warning for a different schema means that the tables you are trying to bring in aren't identical in structure - this could be the field names, the order of fields, data types within the fields etc. and so you'll need to check that they're all the same, otherwise you'll need to take a different approach; usually a batch macro.

[Luke_C]

Hi @kiranjoka 

This will happen if all the tables/files do not have the same schema (meaning, same exact columns and field types). Without seeing any example data it's tough to say what your issue is. Do they have the same schema or are they different? If they are the same you may need to go the batch macro route. 

[Felipe_Ribeir0]

Hi @kiranjoka 

This is the best community post that i saw explainning the problem and providing a macro to solve it. Read the post, download and test the macro and it will work :) : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[binuacs]

@kiranjoka The below post might be helpful for your use case 

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

[messi007]

@kiranjoka,

For this case you have to use a batch macro.

Please take a look here : https://www.thedataschool.co.uk/vivien-ho/how-to-import-files-with-different-schema-using-a-batch-ma... 

Regards,

[dunkindonut7777]

hello beginner here. how can I download the alteryx file of the sample flowchart presented so that I can have a guide and follow it.