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.

Challenge #139: Spooky API Connection

Asteroid

Here is my solution...

 

I removed my key...

Alteryx Certified Partner
Spoiler
wk139.PNG
Aurora
Aurora

Used a fuzzy match process to get around the spelling of atomic ( :-) thanks for spotting and fixing this @patrick_digan and @JoeM )

 

Spoiler

2018-11-18_18-51-36.jpg2018-11-18_18-51-46.jpg2018-11-18_18-51-56.jpg

Meteor
 
Meteor

That is truly a spooky amount of calories!  

My solution:

 

Spoiler
139 EW.PNG
Asteroid

This one was more difficult than I initially thought! I also manually corrected the spelling of "Atomic Fireball".

 

Spoiler
Also, note that the solution uses nutrient.x.value, which means we're assuming that the bag Qty is number of 100-g servings (not pieces). So, we're assuming 30 x 100-g servings of candy corn (3 kg or 6.6 lbs of candy corn!!) and not 30 pieces of candy corn. 

No wonder it's 34,795 calories! Given that assumption, the whole bag is 8,800 grams or 19.4 lbs! Now, that is a candy haul!

If we use the nutrient.x.measures (assume the bag Qty is in pieces), then we get a much more reasonable(-ish) 4,256 calories for the bag. I calculated it both ways (assuming Qty = 100-g servings, and also assuming Qty = pieces), because I was curious!

challenge_139.png
Alteryx Certified Partner

Got it after spotting the typo :)

Asteroid

Challenge Completed

Alteryx Partner
Spoiler

solution 139.png

Asteroid

Solved. Inelegant. Barely holds together. But works.