How do you show the count when you use group by and count in alteryx?

[Mackenzie_1]

For example, lets say you have this table:

Name

Absa

Absa ltd

Absa Pty ltd

Amazon

Amazon ltd x

Microsoft

Apple

Google llc

Google

Absa

Absa'

Name                 Group By

1-Absa                2

2-Absa'               1

3-Absa ltd           2

5-Amazon           1

8-Google            1

Name                         Group

5-Amazon                   1

6-Amazon ltd x           1

1-Absa                        2

2-Absa'                       2

3-Absa ltd                   2

2-Absa'                       3

3-Absa ltd                   3

3-Absa ltd                   4

Absa Pty ltd                4

8-Google                     5

9-Google llc                5

3-Absa ltd                   6

4-Absa Pty ltd             6

So I would like to find out the groups of the names then organize all of the names associated with each other in a list under one group number. How would I do this ?

[PeterAP]

Hi @Mackenzie_1 

Are you looking to group entities with similar names together with an output similar to the below? If so, you could make use of the attached workflow which groups your fuzzy matches into groups with similar names using the "Make Group" tool. 

[Mackenzie_1]

Hi @PeterAP thanks so much, this solves my issue.

[PeterAP · Accepted solution]

@Mackenzie_1 

No problem. If you could mark it as solution then it may help others with the same problem. Thanks!