community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #56: Parsing and Counting Hashtags

Asteroid

PFA my solution

Asteroid
 
Asteroid

Solution attached

Meteor

Done!

Highlighted
 
 
Asteroid

That was fun and thank you @JoeM for the great learning resource RegexOne!

 

Spoiler
2019-10-08 14_47_22-Greenshot.pngCross tab, multi-field formula, and add totals for the win
Asteroid

Cool @Harbinger thanks for sharing RegExr!

Alteryx Partner

Avoided the temptation to go brute force and design this so it would still work if the data was updated (at least, I think it will)

 

Spoiler
Process:
- Tokenize on '(#\w+)' - split to rows
- Remove Null records
- Summarise data (Group By "text" and "id_str", and Count "id_str" - renamed "test" as "hashtags" renames "Count" as value (that last bit not really necessary))
- Cross tab (Group by "hashtags", Column Headers - "Group By_id_str", Values  - "value"
- Dynamic rename to remove "Sum_" from Column Headers
- Dynamic rename to add "Id_str_" to column headers
- Replace Null with "0"

MySolution.PNG
Alteryx Partner

My solution

 

Spoiler
challenge_56_RODO_Solution.png