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 softwa...
= 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
I was hoping there was a way to get it to automatically create the list of softwares so I don't have to manually search through 27,000 software instances to figure out what to group them by