Mixed boolean values
What they are and how to fix them
What are mixed boolean values?
Columns that mean yes or no often mix values like true, yes, 1, TRUE, and Yes. That breaks filters, formulas, and database types. RxLint finds inconsistent boolean-like values so you can normalize them to a single format.
Example data with this issue
| name | active |
|---|---|
| Alice | true |
| Bob | yes |
| Carol | 1 |
| Dave | TRUE |
Frequently asked questions
Why does mixing yes/no formats matter?
Tools that expect a single format, such as true/false, may treat yes or 1 as plain text and break filters, pivots, or type-safe imports.
Can RxLint normalize to one format?
RxLint highlights all inconsistent values in the column. You can then apply a quick fix to standardize them to true/false, yes/no, or 0/1.