Alteryx Designer Desktop Discussions

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

Multi row formula tool

Meoth
8 - Asteroid

Hi,

 

I have attached the sample flow which has two containers of Multi row formula tools. Both containers has same logic/calculations but applied in different columns.

Is it possible to create the calculations applied in Multi row formula into Iterative Macro? 

 

Many Thanks!

3 REPLIES 3
DawnDuong
13 - Pulsar
13 - Pulsar

hi @Meoth 

Of course it's possible to use iterative macro.

But you don't need to use macro to achieve the same thing. 

You can do the following steps:
1) UniqueID tool to uniquely identify each record.

2) Transpose the columns that you want to apply this Multirow formula.

3) Make sure you add a Sort tool to preserve the original sequence.

4) Select "Group by" in the Multirow tool and use the same formula as before.

5) Then cross tab back based on the UniqeID as identifier.

Should be straightforward (single branch only) so i did not attach a workflow.

Dawn.

Meoth
8 - Asteroid

Thanks @DawnDuong for the quickest response. Could you please attach the workflow too? It would be really helpful

Meoth
8 - Asteroid

Hi @DawnDuong, could you please attach the workflow too? 


Many Thanks!

Labels
Top Solution Authors