Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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 #415: Efficient Resource Distribution Using Macros

JoeOC1234
7 - Meteor
Spoiler

batch macro:

Screenshot 2025-02-12 162237.png
alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-02-17 111054.png
lwolfie
11 - Bolide

I had downloaded this one a while back and the start file doesn't say macro in it.  I'll go back and use a macro to solve it.  For now, here's my non-macro method.

lynnesonney
8 - Asteroid

I love seeing so many ways to attack the same problem!

nrbarcia_4
7 - Meteor

Whew, this one stumped me for a bit but I came out the other side wiser and better! 

 

Spoiler
solution 415.pngbatch 415.pngiterative 415.png
JBevan89
8 - Asteroid

Another good challenge

TH
8 - Asteroid

I can see how macros might be used for this challenge.

I did not need them. I found that simply using the "group by" function of many tools was enough.

Also, this challenge was poorly stated. There were a things that I had to figure out simply by looking at the data and at the desired solution. I liked that there existed multiple ways to accomplish the objective here.

In the end my solution was very simple. The join at the end is just for checking my answer.

Spoiler
Alteryx Challenge 415 Screenshot.png
Carolyn
12 - Quasar
12 - Quasar

Solved! I went the non-macro route

 

Spoiler
2025-07-15 11_15_16-Alteryx Designer x64 - Challenge_415_Carolyn.yxmd.png
Erin
11 - Bolide

I had to read through the comments and posted solution for this one, and agree with @RWvanLeeuwen that more details about the objective/nuances of the data would have been nice. I did it without a macro only because I like to visualize everything when I can. 

 

Spoiler
415.jpg
JosephSerpis
17 - Castor
17 - Castor

Challenege Completed

 

Spoiler
Screenshot 2025-08-17 152021.png