Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience
SOLVED

Challenge #135: Locker Problem

Alteryx Certified Partner

Done :-)

Highlighted
5 - Atom

I first did it using a bit of python 'cos I'm a developer so that's how I think but that felt like cheating so after having a sneaky quick look at some of the other answers layouts I tried a cross-join approach.

 

Spoiler
Challenge135.png

 

Highlighted
8 - Asteroid

Learning new things today.

Highlighted
Alteryx Certified Partner
Spoiler
Great opportunity to refresh the iterative macro skills.
Capture.JPG
Highlighted
7 - Meteor

only requires 1 tool

Spoiler
Screen Shot 2018-10-22 at 10.39.37 AM.png
Highlighted
8 - Asteroid
Spoiler

challenge_135-PP.JPG

 

 
Highlighted
Alteryx Partner

Ran query with a join rather than a macro to see if it would be quicker

Highlighted
Alteryx Partner

Solution attached. This was a particularly satisfying weekly challenge.

Highlighted
8 - Asteroid

Tricky getting my head around the iterative macro, lots of fun though

Highlighted
14 - Magnetar
14 - Magnetar

Really getting the hang of iterative maros :)

Spoiler
The workflow:
image.png

The Macro:

image.png