Multi row formula tool

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!

Multirow Calculation.yxmd

Macros

Accepted answers

DawnDuong

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.

All comments

DawnDuong

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703