Forum Discussion
Automatically group text with words in common
I think this is a long shot but I am going to ask anyway. I have a dataset with a list of computers in our company and what software is installed on each computer. There are over 27,000 unique softwares in this dataset, but many of them are similar. For example, there are over 1,200 unique software names that contain 'ArcGIS', some of which are updates and different versions of the same software.
I there a way to automatically group softwares with a common word, such as 'ArcGIS' or 'Firefox' without me having to go through and figure out what words to group by?
| Install Date | Installed On | Software Name | Software ID |
| 2022-06-29 | f6de9bb21bc4441052b33224cc4bcba5 | Autodesk App Manager | 252c67fc471fcd90e9d97134846d430c |
| 2021-11-18 | 2e4f2e881b8c1850947d41d8cd4bcb58 | ArcGIS Desktop 10.6.1 TLS Patch | 42a572721b8404108f40fc49cc4bcb72 |
| 2022-10-03 | 9f5c2a2587a01d90227d87b7cebb35dd | ArcGIS Desktop 10.5.1 | 2b0fb2761b00441052b33224cc4bcbfb |
| 2021-09-01 | f6de9bb21bc4441052b33224cc4bcba5 | Adobe Character Animator 2020 | 7ecfb79d472011d4e9d97134846d43a0 |
--
3 Replies
= let SoftList={"Autodesk","ArcGIS","Adobe"},fx=(t)=>List.PositionOf(SoftList,t,0,(x,y)=>Text.Contains(y,x)) in Table.Group(SampleData,"Software Name",{"tbl",each _},1,(x,y)=>Value.Compare(fx(x),fx(y)))
you can add new software name in the SoftList
