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

TimofeyKapustin
5 - Atom

Iterative macro solution to Challenge 135

Martyn
9 - Comet

Nice to get some practice with iterative macros.

 

Spoiler
clipboard_image_0.png

clipboard_image_1.png
RWvanLeeuwen
11 - Bolide

Workflow

Spoiler
135 workflow.png

 

Macro

Spoiler
135 macro.png
alex
11 - Bolide

Stay away from locker 840 during cold and flu season or an outbreak of the cooties.   I outputted the results from all the iterations to see which locker would have been touched the most times.

Spoiler


135 workflow135 workflow135 Macro.PNG
Etienne
8 - Asteroid

Solution below

 

Spoiler

A bit new to the Macro challenges, I've created a batch macro to run for each student.

Next do a locker count and use the modulo function to add an "open" or "closed" tag.

 

clipboard_image_0.png

clipboard_image_1.png

 

dsmdavid
11 - Bolide

Iterative route

Spoiler
1.Main WF

DataDataiterativeiterativeMain WFMain WF

Can't attach here

clipboard_image_0.png

... so find the package in Github: https://github.com/dsmdavid/Alteryx-Weekly-Challenge/blob/master/submitted/sub_Challenge%23135/David...

 

rougeau14
6 - Meteoroid
 
Joe_Beaven
7 - Meteor

Done!

Spoiler
#135 (Macro).PNG

#135.PNG

Nicholas_Bowskill
7 - Meteor

I remember this one took me a while to figure out... The lack of tools is deceptive

OllieClarke
15 - Aurora
15 - Aurora

How bored are these students?

Spoiler
workflowworkflowiterative macroiterative macro