has a different schema than the 1st file in the set

[Nethaji_5]

Hello All,

I'm a beginner at Alteryx. 

I'm facing an issue "has a different schema than the 1st file in the set" while using the dynamic input tool. My team members have put the file in the common shared drive then I used the dynamic input tool to pick all the data and send the consolidated output to the managers.

I do not have any idea on this issue, it may data type or any other issue. 

Please provide me possible ways to resolve this issue. 

[JosephSerpis · Accepted solution]

Hi @Nethaji_5 that error would indicate there is some difference in the data this post provides a guide on scenarios like this and even has an example workflow which I think you would benefit from in this case. If you wanted to investigate the difference between the files I would suggest you input the files into Alteryx with Input Data tools and then use a Field Info Tool which will help identify the differences. 

[grazitti_sapna · Accepted solution]

Hi @Nethaji_5,

The schema also looks for changes in field type/size, not just name.  To avoid this error, you could build a batch macro where the control parameter updates an Input tool, rather than using a Dynamic Input tool. 

You can go through these links about similar issues:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Different-schema-than-the-1st-file-err...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Dynamic-Input-The-file-quot-xxx-...

I hope it helps.