# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #1: Join to Range

Highlighted
6 - Meteoroid

Starting from the beginning...

Highlighted
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
Highlighted
7 - Meteor

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

Highlighted
Alteryx

Solution attached.

Highlighted
5 - Atom

Interesting comparing this to vlookup using true

Highlighted
Alteryx Partner

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

Cheers,

8 - Asteroid

Solution for Challenge 1.

Highlighted
8 - Asteroid

Solution attached:

Highlighted
5 - Atom

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!

Highlighted
6 - Meteoroid

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