Forum Discussion
mtrevisiol
Helper V
5 years agoReplace multiple values in one column
Hi everyone, I'm new to the forum! I've got some problems with power query. I have a column with some names and some of them are mispelled. This is an example: Name Alex J Alex J.. Al...
- Anonymous5 years ago
I'm not sure if there is a replacement limit per column but there are several ways to solve your issue:
1- Create a new column for the Name and then write a switch or if else statement to replace mispelled names with the correct names
2- Create a table that maps the mispelled names with the correct names and then use the Name column of the new table or add add a new column in the original table with Related() or Lookupvalue() function
After doing one of the above, you can delete the original Name column so that it won't confuse report builders
Anonymous
5 years agoNot applicable
You could Text.Uppercase the columns in both tables,which would make it easier to do a
Table.FuzzyJoin!
--Nate
mtrevisiol
Helper V
5 years agoThank you!