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 ?

Names group by.yxmd

Topic of Interest

Accepted answers

PeterAP

@Mackenzie_1

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

All comments

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.

Fuzzy Match and Make Group.yxmd

Mackenzie_1

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703