Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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 #374: Using Iterative Macros

Matt_Davis
7 - Meteor

I had to add a 'Factorial' column to the original text input that was the same values as the 'Number' column to set up my macro:

 

Spoiler
Each iteration updates that 'Factorial' column until it's completed.  

Challenge 374 Completed.PNG
Factorial Macro.PNG

 

 

 

  

Watermark
12 - Quasar
12 - Quasar

Rather odd, it's such a simple form it doesn't need an iterative macro, so it took me a minute to figure out how to force one. Momentary hiccup on data format (hint). Good exercise to work through however. 

 

Only going to bother with the macro since the other is just input/macro/browse per requirements. 

 

Spoiler
MT_Solution_374.jpg

 

 

 

 

jacobcarman
9 - Comet
Spoiler
Spoiler:

jacobcarman_0-1685999302347.png

 

Took me forever to figure out how to get the Factorial field in there to begin.

elena_mazareanu
8 - Asteroid

Solved

PhilipMannering
16 - Nebula
16 - Nebula

I've previously always initialized the field being calculated to pass into the macro, so this was a challenge! Looks like a union with a Text Input to ensure the field is the way to go.

 

Spoiler
PhilipMannering_0-1686041371031.png

 

Christina_H
14 - Magnetar

My macro attached

Spoiler
Christina_H_0-1686044255600.pngChristina_H_1-1686044357667.png

 

 

CharlotteGuy
8 - Asteroid

CharlotteGuy_0-1686054479678.png

 

oneillp111
9 - Comet

My solution, macro attached

 

oneillp111_0-1686056176176.png

 

bkclaw113
9 - Comet
Spoiler
bkclaw113_0-1686058863297.pngbkclaw113_1-1686058877129.png

 

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1686059633458.png

 

olga_strubbe_1-1686059665818.png
A neat challenge, thank you.  Helped me learn iterative macros.  I used a similar approach to @ahsanaali!  Thank you, @ahsanaali  for pointing me in the right direction!