Error schema for the output changed between iteration

[Malek22]

Hello all, 

 Please note that I have created a Macro instead of Dynamic input and im trying to add multiple file on it, the Macro works fine with some folders but the rest of the files I got the error  schema for the output changed between iteration , any ideas to avoid this error ? 

 Thank you 

[pedrodrfaria · Accepted solution]

Hi @Malek22 

Are these files supposed to have the same schema? For example different period versions of the same report? Or are they completely different files? The issue is that the current schema does not match with the previous ran in the macro.

Are you able to provide some more context? Or the workflow for example?

Pedro.

[BrianR · Accepted solution]

In addition to @pedrodrfaria's comments, you will find this message appearing when you run your workflow containing your macro, as your schema will most often change as a result of any number of workflow elements. What you can do is, right before your iteration, place a select on the canvas, and make sure you set the shape of the data to match what your original input tool is expecting. For example, if within the macro, you have added a new field via a formula, your input data doesn't know about that newly added field, so when the iteration occurs, that message will appear.

[nrubner1]

I have found that sometimes I get this error with similar looking files because there is deleted metadata in blank columns, and Alteryx wants to read in these extra columns on some files and not in others. However, I still want the macro to work because the active columns are consistent between files. 

The way I get round this is the following:

1. Within the macro workflow, go View > Interface Designer
2. Navigate to the settings cog of the Interface Designer
3. Change to "Auto configure by Name"
4. Save macro and re-run workflow