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
 
Highlighted
8 - Asteroid

Cadbury's Heroes all Halloween for me!

Highlighted
Alteryx
Alteryx

Hi all,

 

here is my Solution, just quickly built this together, so there is probably room to improve it. I was lazy about parsing the JSON really, so I just used a filter looking for kcal and then, knowing that the actual value is in the next row, just used a RecordID +1 Formula to create a "RecordID Kcal" and then use a Join tool with the original data coming back from the Download tool to get the Kcal value, its a common technique I use usually when building Website Connectors with Alteryx.

 

Cheers

Olli

Highlighted
6 - Meteoroid

My first ever Weekly Challenge attempt

Highlighted
Alteryx Certified Partner

Not as easy as I thought :p

 

Also I assume Atmoic Fireball is a typo

 

 

Here is my solution!

 

Highlighted
13 - Pulsar

Here is my solution!

 

Spoiler
Workflow & ResultsWorkflow & Results
Highlighted
17 - Castor
17 - Castor

That's one big, bloated tummy!

 

tummy.png

 

Spoiler
I took advantage of the fact that the USDA provides XML data and use the XML parse tools to find what I needed

Solution.png



Dan

Highlighted
6 - Meteoroid

First submission, not the most elegant though!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I also changed the spelling. 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
Cool exercise!

Here's my solution. 

Solution_Challenge_139.PNG