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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed 

Highlighted
14 - Magnetar
14 - Magnetar

One tool solution!!!

 

Spoiler
Took me a while to find the right code (thank you once again, StackOverflow!!), but I managed to find my solution using only the R tool, rather than just loading the data and then using regular Alteryx tools.

Definitely not the most intuitive programming language to dive headfirst into (having had exactly 1 experience in Python and 1 in R, I'd currently vote for Python... though clearly this sample size is lacking haha), but it at least started making more sense by the end. 

WeeklyChallenge160.JPG

Note: Thanks to @patrick_digan for unwittingly helping with my solution - I definitely took a shortcut and just "borrowed" your logic for determining the lower & upper bounds of each carat range 🙂

Cheers!

NJ

Highlighted
12 - Quasar

Solution attached

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Got tripped up and couldn't figure out why my R tool wouldn't bring in the data. Turned out being something super simple again.. I was using backslashes when the tool needed forward slashes!

Capture.PNG
Highlighted
Alteryx Certified Partner

Here's my solution

 

Spoiler
Screenshot 2019-06-23 at 18.36.17.png
Highlighted
7 - Meteor

Still pretty new at this so it took a minute to figure out the R tool

Spoiler
Untitled.png
Highlighted
Alteryx
Alteryx
Spoiler
Fun little challenge with some R.  
Highlighted
Alteryx Certified Partner

12

Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

any tips on how to make this file path relative to the workflow would be appreciated

Spoiler
160.png
Highlighted
7 - Meteor

Fun challenge! My solution attached.

Spoiler
160.jpg