Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
SOLVED

Challenge #135: Locker Problem

Alteryx Partner

Iterative macro solution to Challenge 135

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

 

Alteryx Partner

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

 

6 - Meteoroid
 
7 - 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

Alteryx Certified Partner
Alteryx Certified Partner

How bored are these students?

Spoiler
workflowworkflowiterative macroiterative macro