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 #205: Taynalysis

Highlighted
8 - Asteroid

Hi everyone,

 

I quite enjoyed this one and once again, I avoided regex! I will learn it one day, I swear.

 

Have an otter:

danespoors_0-1583485747827.gif

 

Dane.

 

Highlighted
12 - Quasar

Very fun challenge! I look forward to seeing some other ways this can be done. Not sure my solution is the most efficient.

Spoiler
Challenge 205.PNG
Highlighted
Alteryx Certified Partner

Challenge 205 is done!

 

Spoiler
challenge 205 JMS solution.PNG
Highlighted
8 - Asteroid

Here is my messy solution with probably too many tools. Happy Friday everyone!

Highlighted
Alteryx Certified Partner

This is my solution.

 

Spoiler
Firstly, I use unique tool, but result is not correct. So I use Summarize tool, it works well.
クリップボード一時ファイル01.png

Highlighted
7 - Meteor

I too have some minor discrepancies on the duplicated lines exercise. My suggestion to give a crack on the Regex tool. It is a beautiful and elegant solution after cracking my head. 

 

Number of tool used (not including browse for results): 20

 

Spoiler
Challenge205 Flow - Regex.JPGChallenge205 Flow - Overall.JPG
Highlighted
8 - Asteroid

Attached is my approach to solving it, but numbers are not matching,

 

looking forward to seeing the solution

 

 

Highlighted
Alteryx Partner

I had everything correct but my overall #'s weren't correct. I was using the data cleansing macro instead of @patrick_digan 's approach with the replacechar() which for some reason is exactly what it needed. Once I swapped that out, my numbers tied

 

Highlighted
8 - Asteroid

Here is my answer.

 

It's not 100% matching for all albums but it's very close.

 

Spoiler
challenge_205_alozano.jpg
Highlighted
8 - Asteroid

My solution

Spoiler
Challenge_205.png