Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

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~