Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA
SOLVED

Challenge #135: Locker Problem

adams_ca
8 - Asteroid

My solution 

 

Spoiler
CA Solution - Iterative Macro.JPGCA Solution Workflow.JPG
Kenda
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG



2.PNG
papalow
8 - Asteroid

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

nickjastrzebski
8 - Asteroid

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

 

Spoiler
Workflow:
image.png
Spoiler
Macro:image.png
TonyA
Alteryx Alumni (Retired)

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

 

LordNeilLord
15 - Aurora

34

 

Spoiler
Capture.PNGCaptureIT.PNG
joemkcarr
8 - Asteroid
 
redd1976
7 - Meteor

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.

Alekh
9 - Comet

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

 

NikolajFrosig
7 - Meteor

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