Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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

DMContente
8 - Asteroid

Here's my probably over complicated solution

BeginnerMindset
8 - Asteroid

Fun challenge. Thanks

Toons
12 - Quasar

My solution with iterative macro :

 

Spoiler
Workflow :
workflow_locker.png
Macro :
macro_locker.png

 

 

DarekS
7 - Meteor

Solved!

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1611965615886.pngToons_1-1611965630636.png

 

 

apathetichell
20 - Arcturus

This was my first iterative macro (and it's my first time uploading a weekly challenge answer.) and I was having some issues using the macro generated row iterator for my MOD function so I created a variable to mimic it and got everything to work out.

KilianL
Alteryx Alumni (Retired)

I was thinking of a direct approach using prime factorization, but went for the straightforward iterative macro.

 

Spoiler
135 - Locker Problem - Kilian.png135 - Locker Problem Iterative Macro - Kilian.png
TraceyD
Alteryx Alumni (Retired)

Good one!  My solution:

rcarog
8 - Asteroid

Solution attached.

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1617668002402.png