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 #130: Is There an Echo in Here?

Highlighted
8 - Asteroid

My solution attached.

Highlighted
Alteryx Certified Partner

My solution :)

Spoiler
challenge_130.PNG
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Had to pull out some new RegEx tricks, but was able to get the one tool solution!

Capture.PNG
Highlighted
6 - Meteoroid

My solution! ...

Spoiler
challenge_130_zsm_solution.png
Highlighted
8 - Asteroid

Fun challenge!  I don't know if the Python tool counts as a one tool solution or not, but I wanted to try tackling this using Python to get some practice using the new tool!  I also tried using just base Python (except Pandas to create a new dataframe since Alteryx can only write out dataframes) and tried to avoid using regex.  I also added one more phrase "It's going to be a great great, fun-filled day day!" just to make sure I was still capturing the correct punctuation mid- and end-sentence.

 

Spoiler
Challenge 130 Screenshot.JPG
Challenge 130 Screenshot 2.JPG

 

Highlighted
8 - Asteroid

I had to do some research on RegEx but it seems to work.

Highlighted
Alteryx
Alteryx

Beat my head against the one tool solution for a while but finally got is. I included the basic tools solution as well.

Spoiler
Took a lot of googling around regex sites to sort this out and then I had to figure out how to use the replace option.
Highlighted
Alteryx
Alteryx
 
Highlighted
Alteryx Certified Partner

38

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Here's my solution!

Spoiler
Capture.PNG