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, 2022 in Tableau by Vaani
• 7,070 points
771 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, 2022 by Neha
• 9,020 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,240 points
9,891 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,030 points
17,025 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,240 points
11,726 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, 2022 in Tableau by Vaani
• 7,070 points
512 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
460 views
0 votes
0 answers

Tableau Map view Continent List

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
579 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, 2022 in Tableau by Vaani
• 7,070 points
589 views
0 votes
1 answer

How to share a workbook with client in Tableau who do not have Tableau account or tableau reader

It's possible that there isn't a way ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,020 points
656 views
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, 2022 in Tableau by Neha
• 9,020 points
990 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP