Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

amenard
6 - Meteoroid

1. Formula tool: In spoiler

 

2. Join tool: Joined on region

 

3. Sum tool: group by region, sales rep and responder, Count by store number 

Spoiler
Spoiler
Spoiler
 Formula tool: If [Postal Area]>=2000 && [Postal Area]<=2019 then "R1" elseif [Postal Area]>=2020 && [Postal Area]<=2039 then "R2" elseif [Postal Area]>=2040 && [Postal Area]<=2059 then "R3" elseif [Postal Area]>=2060 && [Postal Area]<=2079 then "R4" elseif [Postal Area]>=2080 && [Postal Area]<=2100 then "R5" else "" endif 
yashwanth522
7 - Meteor

Started late but trying to get done and certified! Solved the first challenge and learnt about generating rows using generate rows tool.

DeniseF
Alteryx
Alteryx

Solution attached.

LSmit
5 - Atom

Interesting comparing this to vlookup using true 

Dan_Silva
6 - Meteoroid

Working my way up to the top of the challenge board, wish me luck. 

 

Cheers,

MattBenj
9 - Comet

Solution for Challenge 1.

Nmetzgen1
8 - Asteroid

Solution attached:

dolsen
6 - Meteoroid

My first challenge!

 

Spoiler
I joined the tables on the starting zipcode for each range, sorted the results on the zipcode and used the multi-level row formula tool to fill in the zip codes that didn't match the zipcode of the starting range. 

I can't wait to try more of these!

 

JessieB
6 - Meteoroid

Hi all! This is my first ever solution to an Alteryx weekly challenge. Hope it works--looking forward to doing them all!

MichaelAd
Alteryx
Alteryx

Hi,

 

Please find attached my solution.

 

Regards,

Michael

Michael Adler
Sr. Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.