We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# 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.

## Challenge #374: Using Iterative Macros

8 - Asteroid

Wow!! This was Fun!! Learnt a lot about iterative macros while solving.

Key tip: You can loop additional fields back to source. This is how I could manage with only 1 input column. Please check the workflow for methodology.

Spoiler
7 - Meteor
Spoiler

Great challenge!!

8 - Asteroid

I didnt see any mention in the fine print that a batch macro couldn't be part of the iterative macro 🤠 Welp either way I snuck one in there. You can do operations in a formula tool with plain ol numbers, so the string couch* number cough* was inserted into the formula before the math kicked in 🐎

Spoiler

Any bonus points for using the custom iterative image?!?

10 - Fireball

I am so happy I have completed this challenge! Like some others, I had to create an empty column to achieve my output but otherwise, the solution met all the conditions and the numbers are accurate. Two months ago I couldn't even conceptualize how to approach this so I am so happy I was able to knock it out in less than thirty minutes lol. I will review other solutions to see how this can all be done within the macro and then I will never forget how to make a factorial macro ever again because it has haunted me for too long.

Spoiler
8 - Asteroid

This took a bit.

11 - Bolide

Solved.

6 - Meteoroid
Spoiler
Spoiler
Spoiler

8 - Asteroid

team challenge

8 - Asteroid

PFA

8 - Asteroid

This was crazy hard for me to approach. I tried so hard not to make a null column text input to reference but I gave in. An extremely educative challenge.