For example, lets say you have this table:
Name
Absa
Absa ltd
Absa Pty ltd
Amazon
Amazon ltd x
Microsoft
Apple
Google llc
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 ?
Solved! Go to Solution.
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.
Hi @PeterAP thanks so much, this solves my issue.
No problem. If you could mark it as solution then it may help others with the same problem. Thanks!