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