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

0 votes
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?
Mar 9 in Tableau by Vaani
• 7,020 points
73 views

1 answer to this question.

0 votes

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

IF [column_name] = 'Code-XX'
THEN 'CodeXX'
ELSE [column_name]
END
answered Mar 10 by Neha
• 8,560 points

Related Questions In Tableau

0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,054 views
0 votes
1 answer

How to fetch the previous value in a column or row?

Hi Sindhu, You can use LOOKUP() or PREVIOUS_VALUE() in ...READ MORE

answered May 22, 2019 in Tableau by Cherukuri
• 33,010 points
12,693 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,230 points
10,228 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
62 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
73 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
52 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
82 views
0 votes
1 answer
0 votes
1 answer

How to adjust center axis width in a butterfly chart in Tableau

Concatenated by Dashboard Instead of using a single ...READ MORE

answered Mar 29 in Tableau by Neha
• 8,560 points
73 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP