This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, is there anyone know how to deal with the error "the field schema for the output changed between iterations”？ I have a macro to run through the entire file, every sheet is in the same format but somehow one sheet come up with this error message. Thanks.
Every sheet may look the same, but (especially with Excel) it's very easy to overlook that the schema of one of the sheets changed. It could be that a field name was altered unknowingly or that the import driver is classifying a field as a number when it was a text in the others. Whatever the case is, something is changing. If you don't want to go through the trouble if identifying that, you can adjust your properties of your macro (Interface Designer (CTRL+ALT+D)) and tell it to output the data by their name, essentially how a UNION tool works, which ignores schema variations.
Be sure to inspect if the Auto Field tool is involved as well.
I ran into this error when running a Batch Macro. My field names all matched, but an Auto Field was at the end of my Macro, thus constraining the types/length of data that were attempting to Union and throwing the error.