community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

 

Asteroid

Learning new things today.

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

only requires 1 tool

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

challenge_135-PP.JPG

 

 
Alteryx Partner

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

Alteryx Partner

Solution attached. This was a particularly satisfying weekly challenge.

Asteroid

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

Magnetar
Magnetar

Really getting the hang of iterative maros :)

Spoiler
The workflow:
image.png

The Macro:

image.png