Multi row formula tool

[Meoth]

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!

[DawnDuong · Accepted solution]

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]

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

[Meoth]

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

Many Thanks!