Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience
SOLVED

Challenge #135: Locker Problem

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

Highlighted
Pulsar

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

 

 

Highlighted

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

Highlighted
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
Highlighted
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
Highlighted
Pulsar

Here is my version. 

 

Main workflowMain workflowIteration workflowIteration workflow

 

 

Highlighted
Meteor

Here's my solution :)

 

Spoiler
challenge_135_ShokatAli.PNG
Quasar
Quasar

My solution without macro

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