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

My solution attached.

Highlighted
11 - Bolide
Spoiler
Challenge181.PNG
Highlighted
8 - Asteroid
Spoiler
challenge_181_shvive.png

Ended up using CrossTab because I like my drink shaken not stirred. 

Highlighted
Alteryx Certified Partner

My solution

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Hello @T_Willins 

 

That must have been a pretty good class on web scrapping; the only thing that I don't undersand much is the use of two REGEX operators on the Ingredients group (.*?)

 

The asterisk operator should match the preceeding character zero or more times, and the ? operator should match it zero or one time. I am a little confused on the purpose of the ? operator following the asterisk. It seems that with or without it pulls the same results. Is there any strategy behind it?

 

https://www.boost.org/doc/libs/1_64_0/libs/regex/doc/html/boost_regex/syntax/basic_extended.html

Highlighted
13 - Pulsar

Hi @JORGE4900.  I used the (.*?) as habit as I have had too many times when my wildcard .* returned to long of a string.  In this specific data set it is not needed and (.*) would return the same results.  Adding the ? makes the operator non-greedy.  There is a great page on Perl Syntax at:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/RegEx-Perl-Syntax-Guide/ta-p/1288

 

If you get a chance to take the webscraping (or any other pre-conference classes) at #Inspire I would strongly recommend them. 

Highlighted
Alteryx
Alteryx
Spoiler
Challenge_181_LG.PNG

Niceeeeee

Highlighted
8 - Asteroid

Hi @NicoleJohnson 

 

I really enjoyed looking at your application. Very nice job, and I have to say Frozen Strawberry Daiquiris sound pretty good for a sunny day.

Highlighted
5 - Atom

My first challenge. Not a bad way to learn about how to work in the designer.

Highlighted
8 - Asteroid
Spoiler
181.png