Iterative Macro Throwing Out an Error that an Added Field os Not Contaied in The Record

Question

Hello! Wondering if anyone else has faced a similar issue. I built an iterative macro but then had to add a few more columns in the raw file - so I reviseed the Iterative Macro to take into account of the additional columns in the raw file. However, when I run the workflow, I get an error message saying one of the newly added field is not contained in the record.

Trying to figure out what I did wrong here. When I run the Macro by itself, it runs fine. It also seems like Macro is running within the workflow as well - it's just throwing out an error as well.

Help much appreciated in advance!!!

apathetichell · Answer

My hunch is the data you are looping does not schematically match the data you are feeding in - ie you are dropping fields in the macro either by process (you have a summarize tool or other aggregation where you drop the new fields) or you have a select tool prior to looping and the new fields are not included.

DataNath · Answer

@kkkim are you able to upload your workflow? Will need to be a packaged .yxzp so that it includes the macro and data if so. If not, any screenshots?

My initial thought is to check that your input field name matches those that you're using within the macro i.e. in formula tools etc - check for trailing spaces, underscores instead of spaces and such. If they don't match exactly, change them or enable field mapping so that even if the names are totally different you can tell Alteryx which fields to swap those you've set the macro up with.