Challenge #1: Join to Range

[igornbarros]

Spoiler

[lley124]

Here is my solution. 

[Deepakdevi1989]

Hi there all,

Brand new beginner to Alteryx. My solution was to use formula tool to categorise the postal codes into ranges, then use a join tool to do a lookup to the table. Then used the select records tool to remove the unecessary columns (should probably have been the first step), then used the summarise tool to groupby by region, sales rep and responder and count by responder. Probably not the most simple or easiest solution by far but it matched the output, so im happy as a first attempt.

[ehendershot]

Spoiler

[bkclaw113]

Testing

[JPalay]

Challenge #1

[JPalay]

attachment

[mkeiffer]

Here is my solution!

Working my way through all of the Weekly Challenges!  I moved the customer data from the Text Input Tool to an Alteryx database so the data would load faster. 

[skichiban]

Thanks community, it was indeed a interesting task to practice Alteryx.

But i would like to ask why i need to add extra sorting to make it alike to targeted output, as i notice other solutions didn't use such tools? I have no idea on this, appreciate if there is any insight for me. Thanks so much!

Spoiler

[finnkap]

Nice Challenge