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