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.
Getting started with Designer? | Start your journey with our new Learning Path!
SOLVED

Challenge #135: Locker Problem

Asteroid

My solution 

 

Spoiler
CA Solution - Iterative Macro.JPGCA Solution Workflow.JPG
Pulsar
Pulsar
Spoiler
Capture.PNG



2.PNG
Asteroid

Okay, so my solution does not use a macro -- I like it anyway.

Alteryx Partner

Another good practice with iterative macros. Enjoyed making this one work.

 

Spoiler
Workflow:
image.png
Spoiler
Macro:image.png
Alteryx
Alteryx

Here's my solution.

Spoiler
Probably the shortest Iterative macro I ever wrote. Couldn't stop myself from doing this with a boolean for Locker_Open:
IF MOD([Locker_Number],[Engine.IterationNumber]+1) = 0
THEN ![Locker_Open]
ELSE [Locker_Open]
ENDIF

 

Alteryx Certified Partner

34

 

Spoiler
Capture.PNGCaptureIT.PNG
Alteryx Partner
 
Meteoroid

This was the first time I made and altered a macro-this is a good entry into it. Stood on the shoulders of others to learn here.

Alteryx Partner

I took an extremely inefficient route, but it still works.

 

Alteryx Partner

Went with an itterative macro that open and closes. I used the math function modulo, that i haven't used before. 

Spoiler
Workflow:

Screen Shot 2019-07-30 at 11.43.27.png


Macro:


Screen Shot 2019-07-30 at 11.43.35.png