community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
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

 

Meteor

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

 

 
Meteoroid

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

Meteor

Solution attached. This was a particularly satisfying weekly challenge.

Asteroid

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

Bolide

Really getting the hang of iterative maros :)

Spoiler
The workflow:
image.png

The Macro:

image.png