Challenge #1: Join to Range

[amenard]

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]

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

[DeniseF]

Solution attached.

[LSmit]

Interesting comparing this to vlookup using true 

[Dan_Silva]

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

Cheers,

[MattBenj]

Solution for Challenge 1.

[Nmetzgen1]

Solution attached:

[dolsen]

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]

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

[MichaelAd]

Hi,

Please find attached my solution.

Regards,

Michael