cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Multi-Row Formula with Dynamic Range, or Batch Macro

Highlighted
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:

Untitled.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

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 :-)

 

2018-09-13_18-04-52.png2018-09-13_18-08-45.png

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.

Labels