Forum Discussion
Replace multiple values in one column
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
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
Thank you so much, I used the second option and it worked!