How to fix spelling error in a field or column value using Tableau

Question

In some of the records/rows, the values of a column of the type CodeXX have been misspelt as Code-XX. While performing an aggregate process in Tableau, I'd like to merge all Code-XX to CodeXX. Within a column, how can I merge the misspelt data value with the correctly written one?

Answer 1

You should be able to use a compute field like this:

IF [column_name] = 'Code-XX'
THEN 'CodeXX'
ELSE [column_name]
END