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
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"
- 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"
