New Fields no longer appearing inside macro

CNichols84

Let me start by saying that I'm new to Alteryx so this could be a very simple fix.

I created a macro that I have been using for a long time, occasionally I will add new fields to the workflow, then go into the macro and add a new summarize pulling in that new field. For some reason it no longer updates for new fields. I have tried everything I can think of and the new fields don't show inside the macro to then utilize. 

On the macro input I normally have "Show Field Map" unchecked, in my process of trying everything to fix this, I clicked it on and I noticed that the new fields don't show up there (which makes sense) but the new fields do show as available options in the drop down.

I created a "test" formula, it shows in the select, it will show in the Macro "Show Field Map" dropdown options, but no matter what i can't get it to appear inside the macro.

I feel like there is a simple solution that I am not aware of as a newbie. 

Thanks!

alteryx.png

DataNath

Hey @CNichols84, when you initially set up your macro, in your Macro Input tool you'll have a dataset that you used to create and configure it. You can hit 'Edit Data' and amend that to add the new field.

On the mapping, this just allows you to replace fields that you've used for various purposes inside the macro, with fields in your main workflow i.e. outside the macro. For example, if I set up a very simple macro that groups by a field called [Company] and does a sum of [Revenue], without field mapping, if I then plug a dataset into it which has fields called [Corporation] and [RevenueMade], the macro will error as it is expecting the exact same names i.e. Company/Revenue. However, if I turn on field mapping, I can use the dropdowns to match [Company]=[Corporation] and [Revenue]=[RevenueMade] and Alteryx will replace these references where relevant in the macro, allowing it to run smoothly.

Hope this helps!