Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
18 - Pollux

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
Spoiler
Luke_C_0-1617668002402.png