Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

ReconBen
8 - Asteroid
Spoiler
ReconBen.PNG

EW
11 - Bolide

The cleaning to match the solution was very specific!

 

 

Spoiler
Why not just remove all punctuation with a data cleanse tool?
205_EW.PNG

 

 

leozhang2work
10 - Fireball
Spoiler
205.png

Pretty tricky to get the exact number, I have to compare with the answer. Didn't realise I need to remove all punctuation (except '). Not really agree to with one lyrics calculated based on after removing stop words, while the other is based on before, probably need to be more clear in the instruction.

AndrewSu
Alteryx Alumni (Retired)

my take 🙂 i got slightly different results because I used the text mining functions in intelligence suite.  but general idea is the same. 

allwynthomas24
11 - Bolide

Some differences in the lyrics part may be because I have used Find & Replace Tool... but overall matching with the expected output... Thanks

 

Spoiler
allwynthomas24_0-1636437662763.png

 

juliabarale002
8 - Asteroid

🎼

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1637759409959.png

 

NISCHITHA-98
8 - Asteroid

solution

AJ_36
8 - Asteroid

Anbei meine Lösung 🙂

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT  Solution 205.png