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 #139: Spooky API Connection

Highlighted
8 - Asteroid

Here is my solution...

 

I removed my key...

Highlighted
Alteryx Certified Partner
Spoiler
wk139.PNG
Highlighted
16 - Nebula
16 - 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

Highlighted
8 - Asteroid
 
Highlighted
10 - Fireball

That is truly a spooky amount of calories!  

My solution:

 

Spoiler
139 EW.PNG
Highlighted
11 - Bolide

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
Highlighted
Alteryx Certified Partner

Got it after spotting the typo 🙂

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
Alteryx Partner
Spoiler

solution 139.png

Highlighted
8 - Asteroid

Solved. Inelegant. Barely holds together. But works.