Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi Row Formula - Update via Macro

asifk
8 - Asteroid

Hi Everyone,

 

 

 

please can you assist me, I wish to select certain fields  in a multi-row formula under "group by" through a macro, 

 

Reason being i have multiple multi row formulas and wish to use a macro to select these key fields once and apply to all Multi row Formulas with the macro.

 

Below is a snapshot of my interface for macro

 

asifk_0-1576751873720.png

 

and my actual macro is below

 

asifk_1-1576751992871.png

 

Once i am able to update the fields from the first formula, i will then need to apply this to all. 

 

This is a real challenge, my current configuration in my action tool is per below:

 

asifk_2-1576752102014.png

 

Thanks and Merry Xmas

 

3 REPLIES 3
JoeS
Alteryx
Alteryx

Hi @asifk 

 

If you change the way that the list box generates it's answer to being the XML of the tool that will be the easist.

 

So having:

 

Start Text - <Field field="
Separator - " /><Field field="
End Text - " />

 

 

Pic1.png 

 

You can then update the XML of the tool in the action:

Pic2.png

 

 

Sample attached as well.

asifk
8 - Asteroid

Hi @Jo 

 

Thank you for your valuable advice, it is certainly well appreciated.

 

 

Kind regards,

Asif

JoeS
Alteryx
Alteryx

No problem at all, happy to help!

Labels