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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #139: Spooky API Connection

simbert
8 - Asteroid

Surely there is a way to clean the Bag input with one RegEx tool...

Spoiler
clipboard_image_0.png

 

ecarter-93
8 - Asteroid

Complete!

 

solution 139 image.PNG

Spoiler
 
Bluemoon
8 - Asteroid

Accidentally did it on 2019.3, then downgraded (for server), but I promise it worked...

Spoiler
clipboard_image_0.png
OllieClarke
13 - Pulsar
13 - Pulsar

Slight spanner in the works...

clipboard_image_1.png

OllieClarke
13 - Pulsar
13 - Pulsar

So the API stopped working on the 1st of October, and has been replaced with the FDC API. However, despite following the documentation I could not get this to work. So instead I used Alteryx to download the entire FDC dataset and then worked from there.

Spoiler
challenge 139.png
My answer was slightly different as I had to manually lookup the FDCID, and there were sometimes more than one per candy name. It's still a lot of calories though 🙂
mbogusz
8 - Asteroid

@SeanAdams I tried opening up your solution to see the use case of fuzzy matching in action, but the attachment is the start file, not the solution file 😞

mbogusz
8 - Asteroid
Spoiler
2019-11-17 17_13_20-Greenshot.png
edgarl
8 - Asteroid
Spoiler
edgarl_0-1579751914501.png
rmassambane
8 - Asteroid
 
danicahui
8 - Asteroid
Spoiler
Challenge 139 2020-01-28.jpg