Mixed value types
What they are and how to fix them
What are mixed value types?
Mixed value types occur when a single column combines incompatible types, such as numbers and free text. This leads to type coercion issues, broken calculations, and unreliable imports. RxLint highlights these columns so you can standardize values.
Example data with this issue
| order_total |
|---|
| 12.5 |
| 14.99 |
| pending |
| 18 |
Frequently asked questions
What problems do mixed types create?
Databases and BI tools usually infer one type per column. A single text value in a numeric column can force the whole column to text and break numeric operations.
How should I fix mixed types?
Decide the intended type for the column, then convert or move outlier values so every row follows the same type contract.