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
8 - Asteroid

Starting the journey; my solution posted here.

Highlighted
6 - Meteoroid

My Solution and output:

 

Spoiler
Alt-1.png

 

 

 

Highlighted
7 - Meteor
 
Highlighted
Alteryx Partner

Here's my completed workflow:

Highlighted

My solution is attached, used Generate Rows tool, pretty similar to most here.

Highlighted
6 - Meteoroid

I guess solution is more or less same as @cbridges answer. Attaching the workflow for further reference.  

 

Highlighted

Solution attached!

Highlighted
8 - Asteroid

Simple data blending exercise. Took the customer dataset and used a formula tool to group the postal codes by range. 

 

After blending the data, I went ahead and bumped the dataset back to the lookup table by the join tool.

 

Challenge_1.PNG

Highlighted
5 - Atom

Fun!

Highlighted
8 - Asteroid

Originally used the formula tool, but realized it is not as scaleable solution as generate rows.