Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

Challenge #406: What Is Your Lucky Number for the New Year?

3I_ATLAS
9 - Comet

This is an incredible challenge! I can't believe I solved it with not that many macros in my past. Very creative and a great use case of nested macros, at least in my solution.

I'm not sure about the story, but Mr. Kaprekar is very real and an extremely talented and underrated mathematician! His story is fascinating as well!

My lucky number is 2 which is the 2nd rarest (shared by only 576 other numbers) only losing to 1 (384).  3 and 7 are by far the most popular ones with 24% and 22%.

 

It's also interesting how 7 iterations is the maximum it takes to reach the magical 6147. I wonder if it has some relation to the Kevin Bacon 7 degrees of separation...

Spoiler
WC_406_main.jpgWC_406Macro1.jpgWC_406macro2.jpg

 

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-02-25 135023.pngScreenshot 2025-02-25 135118.pngScreenshot 2025-02-25 135127.png
myastarling
11 - Bolide

I'm not gonna lie, I struggled with this one a bit. I got it to work - maybe not the most elegant solution, but it works.

rmassambane
11 - Bolide

406 with a little help.

Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
For fun, I wanted to see the Min/Max/Avg/Mode of the number of iterations needed to hit the magic number

2025-07-10 10_31_24-Alteryx Designer x64 - Challenge_406_Carolyn.yxmd.png

 

2025-07-10 10_32_44-Alteryx Designer x64 - Macro.yxmc.png
JosephSerpis
17 - Castor
17 - Castor

Challenege Completed

 

Spoiler
Screenshot 2025-08-25 163415.png
ANNE_LEROY
8 - Asteroid

Great challenge

ANNE_LEROY
8 - Asteroid

I love your elegant solution

ANNE_LEROY
8 - Asteroid

@gawa I mean your submission  : without macro but generate rows