Multi row formula tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @DawnDuong for the quickest response. Could you please attach the workflow too? It would be really helpful
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DawnDuong, could you please attach the workflow too?
Many Thanks!
