Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #205: Taynalysis

danespoors
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.

 

cplewis90
13 - Pulsar
13 - Pulsar

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
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 205 is done!

 

Spoiler
challenge 205 JMS solution.PNG
DataTester
8 - Asteroid

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

AkimasaKajitani
17 - Castor
17 - Castor

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

haozhong
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
Assaf_m
11 - Bolide

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

 

looking forward to seeing the solution 🙂

 

 

joshuaburkhow
ACE Emeritus
ACE Emeritus

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 🙂

 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
alozano
8 - Asteroid

Here is my answer.

 

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

 

Spoiler
challenge_205_alozano.jpg
PeterH23
8 - Asteroid

My solution

Spoiler
Challenge_205.png