Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #56: Parsing and Counting Hashtags

Highlighted
6 - Meteoroid
Spoiler
Weekly Challenge #56.PNG
Highlighted
8 - Asteroid

My solution

 

Spoiler
challenge 56 solution Eleonora Nazander.JPG
Highlighted
11 - Bolide
11 - Bolide
Spoiler
Challenge 56.PNG
Highlighted
8 - Asteroid
Spoiler
Weekly Challenge - 56.PNG
Highlighted
8 - Asteroid

At first I thought that my solution was not right, but then I just check on the posted solution and the only difference is the use of the macro to add the totals to each row.

Highlighted
7 - Meteor

Annotation 2019-06-20 151931.png

 

Spoiler
 This is my first time engaging in the weekly challenge, can someone know if my approach/answer is correct?
Highlighted
Alteryx Certified Partner

I felt a bit clumsy whilst building my workflow:

 

Spoiler
Extracting hashtags with RegEx -> cleaning it up and removing hashtags as well... -> restoring the tag -> aggregating steps + final join

 

Spoiler

56.png

 

 

 

Highlighted
8 - Asteroid

My Solution!!

Highlighted
11 - Bolide

Solution attached

Highlighted
Alteryx Alumni (Retired)

Good use of tokenize.