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

rmassambane
10 - Fireball

227

dsmdavid
11 - Bolide

 

Yet a slightly different number of records (16322 for me)

Spoiler
dsmdavid_0-1597065710386.png

 

No option to install the text mining tools for now

balajilolla
8 - Asteroid
Spoiler
Solution Attached
balajilolla_2-1597090232956.png

 

 

 

hanykowska
11 - Bolide

I get slightly different results (but very similar)

 

Assume it comes down to the way the data was cleaned and the set up of the sentiment analysis tool.

 

I have tried to create an interactive chart but couldn't change the colours to what I wanted by using split by type and not separate layers 😔

 

Spoiler
hanykowska_0-1597150465758.png

 

grazitti_sapna
17 - Castor

Here is my solution to Challenge  #227.

Thanks

Sapna Gupta
JennyMartin
9 - Comet
Spoiler
AWC227.PNG

Definitely not an optimal solution but it gets to a result that I would be happy to do text analysis on. Video solution here: https://www.youtube.com/watch?v=ddJHPlmZXOQ&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=31

Data parsing challenge to clean up some comments ready for text analysis. Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-227-comments/td-p/613469
pasccout
8 - Asteroid

Here is the first part... I don't have access to the extra tools

huynv96
9 - Comet

Submit my solution, thanks!

Spoiler
My regex string, lol =))) :
REGEX_Replace([body], "<div[^>]*>|<\/div>|<p>|<\/p>|<a[^>]*>|<\/a>|<noscript>|<\/noscript>|<img[^>]*>|<\/img>|<span[^>]*>|<\/span>|<ol>|<\/ol>|<li>|<\/li>|<BR \/>|\\n|\(Highlight to read\)|<strong>|<\/strong>|Spoiler|<strike>|<pre>|<\/strike>|<\/pre>|<font[^>]*>|<\/font>|<LI-EMOJI[^>]*>|<\/LI-EMOJI>", "")​
Inactive User
Not applicable

Unfortunately I don't have 2020.2.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !