This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Quite possibly the simplest and most elegant Iterative macro I've ever written. It effectively gives a multi-column multirow formula by calculating all the dynamic values for the current row and pasting these into the next row.
So obviously went spatial on part 2. Unless you want to go the macro route, you need to fuse X & Y - so you might as well use spatial.
Still some tricks left though - The multi-row formula always produces a NULL spatial object, there isn't the equivalent of 0. So I injected the 1st record in via a union, which also allowed me to set the initial waypoint. But then you have to remember to detect that initial condition in the expression. With a more complicated expression you could avoid injecting the record.
I could have re-written part 1 using spatial and eliminated a tool, but I didn't...