Alteryx Count formula

[harmful_virus]

Hi Team,

I need the formula to get the required output. can you please help me with formula

Sr no	Name	Required output Count
1	Bala	2
2	Bala	2
3	Vinod	3
4	Vinod	3
5	Snehal	1
6	Apple	2
7	Appe	2
8	Vinod	3

[OTrieger]

@harmful_virus 
Summarise tool is want you are looking for.

[davidskaife · Accepted solution]

Hi @harmful_virus 

Summerize and Join tools work for this: simply group by Name, and Count Name, then join back to the original stream using Name as the joining condition

[aatalai]

@harmful_virus  can also do it this way same as @davidskaife but using find and replace instead of join