Hi All,
Greetings to you !
I have just started to build Macros in my Alteryx Upskilling journey . I am facing a specific challenge for one of the standard Macros that I have built . The Macro allows the user to choose numeric fields which it then converts to the currency format . The fields not chosen are sent out to the output without any modification.
While the Macro is working properly for the original dataset , it is not replicating its functionality on any new datasets. The Drop down continues to show the initial list of fields for the user to select.
It would be helpful if anyone of you can share possible solutions to the above problem.
The macro you set is most likely referencing a static file used in your original dataset. The new dataset may or may not have the same fields / data types and you cannot get the right answer right?
You'll need to provide some data and if you can, export your macro to the community for us to make it dynamic. If you want to do it yourself, consider the field names carefully and have the option for the macro to change with control parameters - and also before your macro, consider adding some data type controls and rename certain fields by condition if you want it to be dynamic.