---
title: "Find / fix data errors and warnings"
slug: "find-fix-data-errors-and-warnings"
updated: 2023-06-07T07:25:12Z
published: 2023-06-07T07:25:12Z
canonical: "userguide.dataclassroom.com/find-fix-data-errors-and-warnings"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://userguide.dataclassroom.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Find / fix data errors and warnings

If some of the data in a column does not match the [Data Type](/v1/docs/data-types) you have allocated, a **red or yellow** warning triangle will appear: ![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1686122100412.png)Hovering on the **fix** triangle will offer an explanation, and the option to **Find / fix** the problems.

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/num_missing_warn(1).png)The **Find / fix tool** appears and the table will scroll to the first row with a problem:

![](https://cdn.document360.io/62f8f41e-e041-42c4-b9bc-8ae1eb45d064/Images/Documentation/image-1686122678556.png)

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.
