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

tochy
8 - Asteroid

 

 

1.JPG

 

Gauthier_B
8 - Asteroid

My first challenge!

I had initially done it through a formula and then used the generate row tool. It simplifies the whole process.

Inactive User
Not applicable

I created min and max zip columns, appended it all together and got a good result.

Kdpalmer
8 - Asteroid

Hi -- Instead of augmenting the second input with rows between the low and high end of the regional range, I categorized the first input's regions into the 5 categories with the formula tool.  I then joined on column from that output which had the information in the bins R1-R5 and used the summary tool -> select -> sort.

 

KP

Mattpannuzzo
7 - Meteor

My solution.

Probably similar to others, relatively easy one.

 

Spoiler
challenge_1_solution_MPannuzzo.png
coolvishruth
5 - Atom

Solution

paultno
8 - Asteroid

Here is mine!  

Kdpalmer
8 - Asteroid
 
DVA
5 - Atom

Hi All,

 

My first post in this community and also my kick-off for the weekly challenge. A great opportunity to learn new things and looking forward to see how others approach the same problem.

 

Danny.

jsdeter
8 - Asteroid

Posting my solution to Challenge 1