Forum Discussion
Fuzzy Grouping
Data Groups are done in the model, not in Power Query or source data.
If you wanted to group them in at Dataflow, you'd need to create a conditional column that would add the right grouping as another column.
if [field] = "Boston's Children" then "Harvard Med"
else if [field] = "something else" then "Harvard Public Health"
and so on.
I'd argue the conditional column is the better way from a modeling standpoint to approach it, but it is more tedious than data grouping drag and drop.
You could create a list to merge and create your values, and a Fuzzy Merge is available which means you don't have to generate one for every 500K possible options.
"You could create a list to merge" when you say create a list are you referring to making a transformation table?
Just saying create a list of items (not a Power Query "List") that could be pulled in and then a fuzzy merge done. For example, if you turned down the sensitivity in Fuzzy Merge, pretty much anything with Harvard in it would match and could be grouped to the Harvard section.
It is like all AI type features though. It may work 95-97% of the time, and the rest you have to keep adding exceptions for.