Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #56: Parsing and Counting Hashtags

jagdeep_singh85
8 - Asteroid

PFA my solution

Ellie_P
8 - Asteroid
 
MattBenj
9 - Comet

Solution attached

JP23
7 - Meteor

Done!

kmbutterfield
7 - Meteor
 
AbbieRoss-Carter
8 - Asteroid
 
mbogusz
9 - Comet

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

 

Spoiler
Cross tab, multi-field formula, and add totals for the winCross tab, multi-field formula, and add totals for the win
mbogusz
9 - Comet

Cool @Harbinger thanks for sharing RegExr!

SueDonim
8 - Asteroid

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
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_56_RODO_Solution.png