Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

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!


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!








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~