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

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 #227: /*comments*/

wwatson
12 - Quasar

my attempt

phottovy
13 - Pulsar
13 - Pulsar

I wish I could try part 2 but our IT department hasn't rolled out the newer version yet.

 

Spoiler
227.PNG
PhilipMannering
16 - Nebula
16 - Nebula

My percentages are a bit off. Looks like I parse out slightly different data from the comments.

 

Spoiler
Report SentimentReport Sentiment
WorkflowWorkflow
TonyA
Alteryx Alumni (Retired)

Here's my solution. I wasn't able to match the number of records either. After a while I stopped trying and just built a solution.

Spoiler
2020-08-03_10-41-16.png
cblazer
6 - Meteoroid

Nice challenge cleaning up data!  Now to start playing around with the Text Mining tools for part 2...

Spoiler
DPU Challenge 227.png
dlopez13
7 - Meteor

Great opportunity to practice using the RegEx tool.  Got within 5 records of the listed output.

 

 

 

Spoiler
dlopez13_0-1596491653382.png

 

Qiu
21 - Polaris
21 - Polaris

Need more work on RegEx.

Spoiler
227-en.PNG
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
227.png

Spent some time trying to match the exact number of lines ... 

DaisukeTsuchiya
14 - Magnetar

I spent time more than my expectation. I wonder why the number of records are not matched with Output.

 

Spoiler
キャプチャ.JPG

 

PatrickB89
7 - Meteor

I hate it when I can't match the solution - But since I'm not alone, that seems to be fine.

At least I think I was able to narrow it down to challenges # 120, 122, 166, 176, 181 and 189 each containing one more empty (=No Text, just images or something) line minus the 124 original posts

16,201 records (my solution) = 16,319 + 6 - 124

Spoiler
PatrickB89_0-1596535291203.png