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

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.

Quasar

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

 

 

@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. 

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
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
Quasar

Here is my version. 

 

Main workflow.PNGMain workflowIteration Workflow.PNGIteration workflow

 

 

Meteor

Here's my solution :)

 

Spoiler
challenge_135_ShokatAli.PNG
Comet

My solution without macro

Alteryx Certified Partner
 
Quasar
Spoiler
Challenge #135.PNGChallenge #135 macro.PNG