community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #139: Spooky API Connection

Asteroid

Here is my solution...

 

I removed my key...

Alteryx Certified Partner
Spoiler
wk139.PNG
Nebula
Nebula

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

Asteroid
 
Comet

That is truly a spooky amount of calories!  

My solution:

 

Spoiler
139 EW.PNG

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 :)

Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Alteryx Partner
Spoiler

solution 139.png

Asteroid

Solved. Inelegant. Barely holds together. But works.