Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

how to count a number of times a string occurs within a column?

Highlighted
5 - Atom

Hi, very new to Alteryx!

 

I have a column full of hashtags that I've taken from tweets - the thing is this column shows the hashtags used in each tweet. Thus some of the hashtags appear twice or more, where they've been used in other tweets. 

What I want to do is be able to count each time a particular hashtag appears in the column, and add this number alongside in a new column. 

I want to do this to see which hashtags appear the most and which the least - does anyone have any advice on how to do this?

i tried count in "Summarize" but that just counted the number of values in the column, 

 

Please and thank you!

 

Highlighted
11 - Bolide
11 - Bolide

Hi @sa99 

 

Welcome! You're very close by using the Summarise tool; it just depends how your data is structured as to how you might now use it.

 

I've attached an example of counting hashtags against 3 different structures of data; hopefully this gives you an answer? Let me know if not!

 

Tweets.PNG

 

 

Thanks

 

Andy 

5 - Atom

Thank you! 

I ended up trying the Frequency Table before you replied, and it did the job! 

Thank you for your response anyway~

 

 

Labels