Error schema for the output changed between iteration

Question

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 Answer

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 Answer

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.