Applying a certain value to many cells at once can save you a lot of time when correcting invalid cells.
The State column is the last column containing incorrect data. This column lists the States from which the customers have rented a movie, using a two-letter code. You can notice that among all the other US state codes, the occurrences of Texas stand out as errors.
Rather than simply deleting the corresponding lines with the quality bar like you did before, you are going to correct one of the invalid cells, and apply the new value to all the cells with the same error. To replace the occurrences of Texas with the correct value, proceed as follows:
In the State column, double-click one of the occurrences
You can now edit the content of the cell. When you delete the previous value, a drop-down list opens, suggesting all the values that are part of the
US State Codedictionary-based semantic type, sorted alphabetically.
Because the code for Texas is not part of the first results
that are displayed, start typing T, to
see which results come up.
The suggestions will become more accurate as you type. But if the expected value can already be found from the original list, you can directly select it.
- From this refined list, select the state code that corresponds to Texas, namely TX.
Select the check box Apply to
- Click Submit.
Note that when the State column is selected, the data is visualized in the form of an interactive map of the United-States in the Data profiling panel.