Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAmy solution, like others, decided to use the arrange tool :). probably could have used a few less tool overall though.
I used the arrange tool too. In 10 years of using Alteryx it's the first time I have used it to solve something, previously I have only used it to see what it did.
Managed to get the solution down to 4 tools as well, which I was pretty happy with!
@GarthMiles - that's a hot tip I haven't heard before! In all candor, I still whip out the help when I have to use this tool as well.
@NicoleJohnson Love your super cute icon, and your icons for other macros!
As a Solutions Engineer who likes to think of easiest solutions, no Macro, no hard path, just simple Alteryx functions (and a little RegEx for some extra spin.
Went with the easy path as I wasn't trying for the style points this morning - just get 'r done.