Find / fix data errors and warnings
Find / fix data errors and warnings
Article summary
Did you find this summary helpful?
Thank you for your feedback
If some of the data in a column does not match the Data Type you have allocated, a red or yellow warning triangle will appear:
Hovering on the fix triangle will offer an explanation, and the option to Find / fix the problems.
The Find / fix tool appears and the table will scroll to the first row with a problem:
You can deal with each problem in the following ways:
- Replace it with something else. Type the value in the box, and hit Replace or Replace all.
- Click Ignore missing values to turn off the yellow warning for empty values.
- Try Make all values numeric. This will attempt to make all values a sensible numeric equivalent, for example "3 cm" will become "3". It can't fix values that are missing or ones that are just words, however. You'll need to use one of the other options for those.
Was this article helpful?