Free Trial

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 #160: Diamonds R Forever

dillonkough
6 - Meteoroid

My solution:

Charity_K_Wilson
10 - Fireball

First time I've used the R Tool, even though I can code in R.  Took me a little bit to figure out how to bring the data thru, but once I had it, everything was straight forward.  

olga_strubbe
11 - Bolide

This was my first time using the R tool.  Thanks to @PhilipMannering to model the solution!  Also it was a good practice for Tile tool.  I've included both smart and manual tile options.  The manual one ties to the solution posted. r-tool.png

ed_hayter
12 - Quasar

Like others had some issues getting the join to the range values to work for ranges under 2

Spoiler
Hence the bombardment of select tools trying to force datatypes to get a solution. Logic is sound and dont see the value in brute forcing the ranges. I'd be curious to know why it was playing up - sampling?

image.png
gawa
16 - Nebula
16 - Nebula

Done

mithily
8 - Asteroid
Spoiler
used R 
tammybrown_tds
9 - Comet

Fun to use the predictive tools.

Spoiler
Screenshot 2023-11-13 144406.jpg
geoff_zath
Alteryx
Alteryx
Spoiler
challenge_160_workflow.png

aatalai
14 - Magnetar

C160

Bobbyt23
12 - Quasar

Never used the R tool before so that was good learning. Then used Generate Rows to create my lookups.