Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a column with the name of cities, but these are written differently, that is, there are grammatical errors. I need to be able to make a filter where I can select multiple city fields and replace them with the correct name.
Example annex for better illustration
Current Correct
Bogota | Bogota |
boogota | Bogota |
Bogotta | Bogota |
Boogotsa | Bogota |
Logically there are many more misspelled cities and I need to normalize the column with the correct values. How do I do this in Power Query? Thank you
Hi @Syndicate_Admin ,
You could use Table.AddFuzzyClusterColumn()
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you very much for the answer, however, this solution would serve me in the case that I previously knew how the city is written, but I do not know that until I make the filter and be able to select the ones I want to change.
Therefore what I require is that once I have selected the rows that contain the value I need through a filter, to be able to change them to the value I need, Thank you