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

joelmiller66
9 - Comet
Spoiler
Challenge 1 Image.png
MartinStraech
8 - Asteroid

Used similar solution.

 

Spoiler
MS - Solution.PNG
cherrington
7 - Meteor

Challenge result

jharber
5 - Atom

My solution to Challenge 1:

Akash_chauhan
5 - Atom

Here's my Solution of Weekly challenge#1: Joint to Range

bann-seamus
6 - Meteoroid

Solution attached:

TKSnider
8 - Asteroid

I know I'm really late to this party, but figured better late than never.

 

Spoiler
I didn't look through the solutions, so I'm sure this was done before, but I used a trick I've used in SQL to do this.  I parsed out the code range into a high and low, then appended the records and checked to see if they were between, if they were, I added a 'keep' flag and then filtered out all the NOs.  Followed that with a summarize tool.  And then to validate the results, I joined my results to the given results using the three key fields.
Mario36
8 - Asteroid

Here's my solution.

ARussell34
8 - Asteroid

Here is my solution!

RamonaJ
8 - Asteroid

Attached my solution