ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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 #436: Part 2 Universal Summer Cup Stats

Powerhouse_21
10 - Fireball

I think I got things semi-dynamic, but it definitely made the workflow longer.

Spoiler
436.png

wbasuki
8 - Asteroid

Here is my solution

Spoiler
Screenshot 2024-08-07 135022.png
Inactive User
Not applicable

My solution 😁

Carolyn
12 - Quasar
12 - Quasar

I feel like I could've done this a bit cleaner, but I got there :) I ended up using the MOD function and RegEx_Match, since those have been my "go to" functions lately 

 

Spoiler
2024-08-07_10-16-43.png
samgiroux
8 - Asteroid
Spoiler
Screenshot 2024-08-07 125530.png
oscar_leeper_wf
7 - Meteor

Thanks Albert Bellamy for the idea to start with the tool I won't mention to spoil it.  I probably could have just used the sums.

Spoiler
Challenge_436_Spoiler.png

 

ChrisTX
16 - Nebula
16 - Nebula

Finally got a chance to use the Dynamic Replace tool.

 

Spoiler
Screenshot 2024-08-07 192721.png

 

ahsanaali
11 - Bolide
Spoiler
436.png

sfarnham1
7 - Meteor

I avoid cross tab whenever I can.

Paridhi_Agrawal
8 - Asteroid

My solution: