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

Question

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 Answer

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 Answer

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-error/td-p/445193

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Dynamic-Input-The-file-quot-xxx-quot-has-a-different/td-p/49982

I hope it helps.