Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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