community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Alteryx Partner

Iterative macro solution to Challenge 135

Asteroid

Nice to get some practice with iterative macros.

 

Spoiler
clipboard_image_0.png

clipboard_image_1.png
Alteryx Certified Partner

Workflow

Spoiler
135 workflow.png

 

Macro

Spoiler
135 macro.png
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.PNG135 workflow135 Macro.PNG
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

 

Alteryx Partner

Iterative route

Spoiler
1.Main WF

135-3.pngData135-2.pngiterative135-1.pngMain 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...

 

Meteoroid
 
Meteor

Done!

Spoiler
#135 (Macro).PNG

#135.PNG

Alteryx Partner

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

Highlighted
Alteryx Partner

How bored are these students?

Spoiler
Challenge 135.pngworkflowChallenge 135 macro.pngiterative macro