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

TimothySr
6 - Meteoroid

My Solution and output:

 

Spoiler
Alt-1.png

 

 

 

Zachary
7 - Meteor
 
KolsumaAktar
8 - Asteroid

Here's my completed workflow:

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

kedark
6 - Meteoroid

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

 

Scott_Anderson
Alteryx
Alteryx

Solution attached!

gguedes1
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

JMedina1117
5 - Atom

Fun!

nakamott
8 - Asteroid

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

DrewKlepzig
5 - Atom

Late to this party. I haven't used the generate rows tool before so this was a good exercise!