Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Multi-Row Formula with Dynamic Range, or Batch Macro

6 - Meteoroid

I'm looking to re-create an XL tool I have (which uses VBA For/Next loops) in Alteryx.


Given a set of A values, of size n, I need to calculate B and C, where:

















I've got a solution for calculating B (using a variety of indexing, appending, and multi-row formulae), but I'm wondering how best to proceed with a solution for C.


Is what I'm looking to achieve possible with (dynamic range) multi-row formulae? Should I be looking into batch macros instead?


Assistance would be appreciated.

12 - Quasar

@Giles  This looked like a great test case for macros so I built a flow that way (see below). As to the question re doing it with multi row formulae wtc, I'm sure that someone cleverer than me will come up with a way but the macro solution was fun 🙂



6 - Meteoroid

That's terrific, @ivoller, thank you. I have numerous similar scenarios which will require solutions, and I will be developing them using your methodology as a template.


I look forward to being as helpful to other members of this community, as you have been to me.