We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Mackenzie_1
7 - Meteor

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 ?

3 REPLIES 3
PeterAP
8 - Asteroid

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. 

 

PeterAP_0-1663770452160.png

 

Mackenzie_1
7 - Meteor

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

PeterAP
8 - Asteroid

@Mackenzie_1 

 

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

Labels