Macro issues with "Field schema changed between iterations"

Hello,

I ran into an error which says "the field schema for the output changed between iterations” when I was running a macro to process two excel files. The structure and field types seem to be same between these two, and the only difference is the fiscal year (FY17 vs. FY18). I'm not sure why it says Field schema changed. I've attached the Alteryx workflows and source files - could someone take a look and let me know what went wrong? Thanks in advance!

Source file.zip

Workflow.yxmd

Macro - TB v2.yxmc

Macros

Accepted answers

jasperlch

Hi @cq

The cause of the errors is that the number of columns or names of column headers (thus, the schema) are different between iterations.

You could fix this by

1. Open your macro

2. Select your Macro Output tool

3. on the Interface Designer panel, click on the Properties icon

4. Update the Output Mode to 'Auto Configure by Name'

The results will then be 'unioned'

Macro - TB v2.yxmc

All comments

jasperlch

Hi @cq

The cause of the errors is that the number of columns or names of column headers (thus, the schema) are different between iterations.

You could fix this by

1. Open your macro

2. Select your Macro Output tool

3. on the Interface Designer panel, click on the Properties icon

4. Update the Output Mode to 'Auto Configure by Name'

The results will then be 'unioned'

Macro - TB v2.yxmc

jasperlch,

Thanks for your prompt response, and really appreciate your help! I was able to change the properties and re-run the macro, however, there is only one data output for some reason (see screenshot below). It does not seem to make sense cause I'd expect there would be at least thousands of data output. Did you happen to know what the issue might be? Thank you!

Screenshot - Output.PNG

jarrod

Hi @cq,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

i do want to point out that you don't necessarily need to do step 2 (don't need to select the macro output tool) - just go to Interface designer, then click on cog to change the output mode to Auto Configure by Name. I tested @jasperlch's solution and it worked for me as stated, so i've marked it as the answer.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!

nhunter

This problem has occured when loading several files within a macro and one or more of them contained only the header row and no data. I have tried a number of permutations of input / dynamic input / dynamic rename tools but I have not yet figured out how to fix the problem.

MichelleMitchellLutz

This worked perfectly for me, thank you!

anhvolmer

I am operating under Version 2022.1.1.42590, and getting to the Properties panel wasn't obvious. In case anyone else is wondering: To get to the properties option to fix the "schema mix-match problem" I had to first make sure the Interface Designer is active:
View> Select: Interface Designer (Ctrl+Alt+D) > Click on the Properties Icon > Update the Output Mode to 'Auto Configure by Name'.

champybh

@cq experiencing the same exact issue where "Auto Configure By Name" only results in one row of output when thousands of records should be returned. this issue is driving me nuts!

jlowe1

I am having the same issue - only one row is outputting! Did you find a solution for this? thanks in advance!

champybh

@jlowe1 When I was testing my workflow I didn't have anything connected to the output anchor of my macro. After attaching a "Select" tool to the output, it returned a result set that I expected. I'm not sure why this fixed the issue but it did. Hopefully this simple fix will apply to you as well.

jlowe1

Oh that's great - that has worked! How bizzare, thank you!

Georgealex

In the calling job (job calling the macro), please specify the Input file as *.xlsx in the path to read through all the files in the folder

\XXX\*.xlsx

n09000

HI all, I was having the same issue and found this thread, however the fix did not work for me. Any reason as to why?

alteryx help error.jpg

ALteryx macro help sss.jpg

in workflow.jpg

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335