Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

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

Nethaji_5
7 - Meteor

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. 

 

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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
17 - Castor

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.

Sapna Gupta
Labels
Top Solution Authors