Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #1: Join to Range

krishnakumare
8 - Asteroid

I  have attached the solution which I devised. This may not be the best way. But, posting it.

VipulThakur
7 - Meteor

Solved this challenge with 3 Tool 

1. Formula 

2. Join 

3. Summary 

 

1. Formula: I use this to Categories Region ( R1, R2, R3) using If elseif formula.

 

2. Join: Joined both using region.

 

3. Summarize: Region, Sales Rep and Responder by Group, and Region by Count

nicks2587
7 - Meteor

Completed

Rain7
6 - Meteoroid

Completed.

 

Spoiler
Rain7_1-1683608999319.png

 

 

LynnPätzold
8 - Asteroid

Felt like I had to do the infamous first challenge ;)

Spoiler
Sol.PNG

Spoiler
 

 

zorecchi
6 - Meteoroid

Left to my own devices, I would've probably used the formula tool to assign the regions by brute force. Haven't learned too much about the generate rows tool, so I followed the general solution for my own education. With only a few regions, this could be done by brute force. But, as the number of regions increases, doing it this way wouldn't be very efficient. Solution attached. Not so much different that the general solution, but uses one less select tool since the second one is unnecessary (the join tool can also serve as the second select tool).

hholloway1
7 - Meteor

Here's my solution!

lucaskro
8 - Asteroid
Spoiler
lucaskro_0-1683814853246.png

 

tristank
11 - Bolide
Spoiler
tristank_0-1683820171948.png

 

Challenge 1 Completed. Good to practice the generate rows tool! 

tristank
11 - Bolide

Interesting approach