Macro

[RamaKeerthana]

i need to create a macro which accepts data input and then do some calculation using the dynamic value from the master file and then do some calculation using formula and then retuen output to the master file

[abacon]

@RamaKeerthana Here is a video on how to build a standard macro. Additionally, there is lots of documentation online on building macros.

https://www.youtube.com/watch?v=rRGJK6n8Cis

Bacon

[RamaKeerthana]

Hi Abacon,

Thank you so much it really helped me. But I have another doubt :I’m trying to send data from my main workflow to a macro using a text box inside the macro. Is there a way to populate the text box dynamically, without requiring manual inpu

t, so the value is passed automatically during workflow execution?

Any suggestions or best practices would be greatly appreciated!

Thanks in advance!

[abacon · Accepted solution]

@RamaKeerthana Look into Batch macros. You would use a Control Parameter instead of a text box to pass the data into the macro.

https://help.alteryx.com/current/en/designer/apps-and-macros/macros/batch-macro.html

Note: On a batch macro, a control input will be created along with the macro input, so you will have 2 inputs with one having an upside down question mark. The batch macro will run for each record passed into the input with the upside down question mark so be careful with that.

Bacon