We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
SOLVED

Challenge #135: Locker Problem

Alt_JP
5 - Atom
Spoiler
2018-10-02 Spoiler - challenge_135_jp.yxmd.png

 

Found a solution without using input files or macros. Takes 0.8 sec to run on my machine.

DavidP
16 - Nebula
16 - Nebula

I discovered the Modulo function and what it does!!! And iterative macros are now a little less scary... My solution attached.

 

However, that was my 2nd attempt. With my 1st attempt I tried to update a sample tool with the IterationNumber as shown below, but for some reason it wouldn't work - it doesn't seem to update the value of N in the sample tool. Does anyone know what I'm doing wrong?

 

challenge135 update sample tool.png

 

 

patrick_digan
17 - Castor
17 - Castor

@DavidP I'm not certain, but I don't think any of the interface tools (action tool included) are able to use/update the IterationNumber. 

clant
8 - Asteroid

I couldnt work out what i was doing wrong until i actually read the instructions properly. I originally worked it so every person would change the status of every locker higher than them not just multiples.

Spoiler
1.PNG2.PNG
StevenBetts
8 - Asteroid

Was pleased to find a solution without having to use macros - I still haven't quite gotten my head around those yet!

 

Spoiler
Challenge 135.jpg
ponraj
13 - Pulsar

Here is my version. 

 

Main workflowMain workflowIteration workflowIteration workflow

 

 

sh0kat
7 - Meteor

Here's my solution :)

 

Spoiler
challenge_135_ShokatAli.PNG
Ladarthure
13 - Pulsar
13 - Pulsar

My solution without macro

CharlieS
17 - Castor
17 - Castor
 
kat
12 - Quasar
Spoiler
Challenge #135.PNGChallenge #135 macro.PNG