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 #181: Ingredients of an Old Southern

Highlighted
Alteryx
Alteryx

A solution to last week's challenge can be found here

 

This week's challenge comes to us from ACE @patrick_digan

 

Using the provided URL, download and parse the data in the recipe for an Old Southern. Create a list of the cocktail ingredients and measurements.

 

Whiskey (and other spirits) and analytics go surprisingly well together.  Head on over to our Events page to join an evening of whiskey tasting and data sampling near you. 

 

I prefer my analytics shaken...not stirred.I prefer my analytics shaken...not stirred.

 

 

 

 

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed!

Spoiler
181.PNG181.PNG
Highlighted
12 - Quasar
Spoiler
Challenge #181.PNG
Highlighted
Alteryx Certified Partner

Similar to @kat just some different words in the formula tool.
Fastest I've gotten a kick at the can

 

Spoiler
Capture.JPG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
16-09-_2019_18-15-11.png16-09-_2019_18-18-51.png

Hhallenge completed ... and got to know a very useful website

Highlighted
8 - Asteroid

Looks like my company's proxy blocks the Download tool (I'll need to research the work-around for that later) so for now I just copied the URL's text into a Text Input tool and worked from there.

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Here is the list.

 

Spoiler
2019-09-16_10-07-00.jpg
Highlighted
13 - Pulsar

Quick challenge.  Put to work what I learned in the webscraping class at #Inspire19.  I might create an app from this website.  Now what's my drink...

Spoiler
Workflow 181.JPG

 

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
I almost always use a Multi-Row Formula tool to create the group field, but luckily this time I remembered JSON has the group already in the name field, I just have to extract it.
Capture.PNG

Whoever solves this gets a free drink prepared by @patrick_digan himself, right?
Highlighted
17 - Castor
17 - Castor

Fun challenge, but I can't say it was "Neat"

 

Spoiler
w.png

Dan