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.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The link to last week’s challenge (exercise #54) is HERE.
2013 Alteryx Grand Prix Lap 1 of 3:
As the Alteryx User groups start the process of selecting their competitors for the 2017 Alteryx Grand Prix I thought it would be fun to bring back an old Grand Prix as the weekly challenge. Note the workflow is in a vertical orientation. Vertical was the only orientation Alteryx had in 2013. Now, we can toggle between vertical and horizontal configurations by clicking on the white space of the canvas, going to the configuration window, and choosing a layout direction.
Want to have even more fun, go to the about box under the help menu and double click the little Colorado flag for an Easter egg that will render the tools the way they looked in 2013.
Have fun solving and remember the competitors were racing each other and the clock! See how fast you can solve this. OH, and there was NO Imputation tool in 2013...
Okay, I don't think I would win any prizes for speed here, but I think I got there:
The original post has been updated with the solution!
Solution. I do not like you, up and down. I do not like you, Sam I am.
I successfully completed Pit Stop 1, though it took me ages to do this in a vertical workflow, and OMG that funky icons!! And of course, the suggested solution is much more simpler than mine.
I have tried and failed several times to get this solution to work, although confident that my calculations were correct it would not validate in the macro.
So I bit the bullet and checked against the solution and found the solution had excluded General Merchandise (not in the instructions) and the format required was short and wide (i was using tall and thin)...so I made all the changes but still no luck. So i resorted to checking the values against the solution and they are all correct....I have no idea why it wont run but hey.....I'm happy with the solution I have provided
@SeanAdams - that's 74! I'm ready for Monday :)
@LordNeilLord - you gotta be proud of yourself - you've torn through these with such passion and speed!