Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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?

MitchyMitch
8 - Asteroid

Well this was quite the crash course on macros for me ^.^' Fun challenge!!

 

Also, my lucky number is 3!

Spoiler
WorkflowWorkflow
BatchBatchIterationIteration
olga_strubbe
11 - Bolide

A fun challenge, thank you, @RWvanLeeuwen!   This was my first time ever including a macro inside another macro - this was quite neat, glad I was able to figure it out :)  Thank you for the tip!

2023-12-31_00-04-35.png

RWvanLeeuwen
11 - Bolide

When I started building out the workflow I did not remember the name of the constant, and I did not know what the number was - lol

 

Here's what I did to find the number so I could ues my favourite search engine to track down the name of the constant:

Spoiler
406 batch.png406 iterative.png406 lucky number.png
LynnPätzold
8 - Asteroid

Really fun one and also good for practising your macro skills. (My lucky number is 5 :))

 

 

Spoiler

Macro:

Screenshot 2024-01-02 145349.png

Workspace:

Screenshot 2024-01-02 145326.png

 

  

alacoume
9 - Comet

I did not do the batch macro to calculate every lucky number for every year, but being born in 1977, i can say surely that mine is 6!

Spoiler
Challenge_406.jpg
PhilipMannering
16 - Nebula
16 - Nebula

Nice challenge. Solution attached.

 

Spoiler
WorkflowWorkflowMacroMacro

And in the Python Tool

Spoiler
image.png
alexnajm
17 - Castor
17 - Castor

Fun one! Made it simpler by focusing on one year and simplifying the output.

Spoiler
Challenge 406 Workflow.pngChallenge 406 Macro.png
binuacs
21 - Polaris
Spoiler
image.png
Milanz
8 - Asteroid

my solution ;-)

 

Spoiler
406ML.jpg

Tofel
8 - Asteroid

My number is 5

 

Workflow:

Spoiler
Challenge 406a.JPG

Batch Macro

Spoiler
Challenge 406b.JPG

Iterative Macro

Spoiler
Challenge 406c.JPG