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*/

Dani_Lin
8 - Asteroid

solved

ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1686306946089.png

Slightly different output but what I have was reading very well so happy to submit.

AHill06
8 - Asteroid

So here is my version, could do a group by i guess on the challenge numbers to see the number of comments, but unable to work out if positive or negative comment as dont have those features but pretty happy with the data cleansing done.

tristank
11 - Bolide

Like many others my numbers weren't exact but I was actually pretty happy with my output (validated with some random sampling). I used a lot of regex tools and sampling to keep testing different cases. In hindsight once I realized the text was wrapped in P's I could've likely eliminated everything else around it. By getting rid of empty rows and nulls my row count went down by a lot.

 

Spoiler
tristank_0-1687467812825.png

 

Eliot_Rich
8 - Asteroid

Hello.

 

The REGEX shown in the proposed solution is instructive, thank you.

However, the Part 1 solution record counts do not tie out.  

On the left the record count after the regex and filter for BODY and before the summation is16325. 

On the right the input record coming into the file has 16319. 

 

Where did the six records go?  

As a number of authors note that they did not "quite" tie out, might the admins review the post? 

 

Thanks. 

 

 

caltang
17 - Castor
17 - Castor

Done. You can get 16,325 by changing the empty text of the field [body] into something other than empty/null(), then the concatenate will pick it up as its own piece whilst the regex (/n) will pick it up as well.

 

This ensures 16,325 in, and 16,325 out. I've tweaked the solution given by Alteryx to better fit this criteria - makes more sense now.

 

Spoiler
 
Screenshot 2023-06-28 090932.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Spurs
8 - Asteroid
Spoiler
Spoiler
Screenshot 2023-06-28 142934.png
fimler
8 - Asteroid

Here is my solution

GabrielaTudor
8 - Asteroid

Good practice for using the text mining tools

Spoiler
Challenge 227.jpg
kaiserj
8 - Asteroid

🙂