Frequency Count

[BRRLL99]

Hi

I'm looking for frequency count

sample:

[FinnCharlton]

Hi @BRRLL99 : looks like you need the summarize tool:

[Emmanuel_G]

@BRRLL99 

Find in attachement a way of doing that simply.

To count the number of occurrences of particular string, you need to use Summarize tool.

The link to the details of using of this tool : https://help.alteryx.com/20223/designer/summarize-tool

Do not hesitate to check as answer if it helped.

[ShankerV]

Hi @BRRLL99 

Please find the expected output.

Many thanks

Shanker V

[ShankerV]

Hi @BRRLL99 

Step 1: Input

Step 2: 

step 3: 

Many thanks

Shanker V

[ShankerV]

Hi @BRRLL99 

step 4: Basic table tool

Step 5: 

Step 6: Text Input tool for Heading

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @BRRLL99 

Step 7: Basic table tool

Step 8: 

Step 9: Last step 

Hope this helps!!!

Many thanks

Shanker V