community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #160: Diamonds R Forever

Asteroid

my solution: 

Spoiler
challenge_159_solution_SP.JPG
Asteroid

Wanted to try and join a lookup table to work like an approximate VLOOKUP, but struggled with it.  Ended up with a formula based solution, but definitely curious if anyone finds a way to accomplish it via a similar method.  

 

Spoiler
160 MP.png
Asteroid

Hi! Here my solution :)

Bolide

Fun challenge! I have used the R tool with an input tool, but not without an input. 

Spoiler
Challenge 160.PNG
The R code I used (I had already unzipped the file):
load("C:/Users/Christopher.Lewis/Save Location/Alteryx Challenges/Big Diamonds/BigDiamonds.Rda")
write.Alteryx(diamondsbig, 1)
Comet

Took a little bit of time to read and comprehend the link to using the R tool.  Learning R and Python coding are on my list.

 

Spoiler
Workflow 160.GIF
Alteryx Certified Partner

I got to show this to the wife, since she is a gemologist and diamond grader 😊

 

It took me some serious time to solve this one.
Struggled with the reading of the rda file, seem I was not the only one who quite didn't get how to use slashes properly.

 

Second was the grouping. At first I hadn't seen the provided Output, so I just went for the quick and easy Smart Tile.
But just before I was to submit the answer I noticed the Output, and found out, that it was not that easy after all 😉

 

Spoiler
After I did manage to read the data, I could the use the formula tool to create the Range, and the group on that and count on carats

2019-04-17 11_57_04-Alteryx Designer x64 - challenge_160_verakso_solution.yxmd_.pngThe WorkflowBut here is a small tip (if you did not know this already)

In order to save some time, and avoid to read the data from the rda file, every time the workflow is run, then I simply added a Select tool and choose »Cache and Run Workflow«
2019-04-17 12_00_14-Alteryx Designer x64 - challenge_160_verakso_solution.yxmd_.pngCache and Run Worklow
The on all the subsequent runs, the workflow would run a little bit faster 😉2019-04-17 11_58_34-Alteryx Designer x64 - challenge_160_verakso_solution.yxmd_.pngUse the Cache

Still Climbing

/Verakso

 

 

 

 

 

 

It was fun to learn the R tool

Bolide
Bolide

Can't skip this one since I'm in the jewelry industry!

Asteroid

My submission!

Fireball

Had to dust off some long-unused R syntax for this one!

 

Spoiler
It would have been much easier to perform the grouping/counting in Alteryx, but I wanted to challenge myself to do it all within R!
challenge_160_workflow.PNG

challenge_160_r_code.PNG