Prevent Y / N column from being Auto-Detected as Boolean column

pyousefi
Level 2
Prevent Y / N column from being Auto-Detected as Boolean column
For my dataset I have over 200 columns with many of them Y/N flag columns. I would like to keep them as text and not infer the type.

There is a checkbox that I am leaving unchecked: Normalize booleans Normalize all possible boolean values (0, 1, yes, no, โ€ฆ) to 'true' and 'false'
0 Kudos
2 Replies
Clรฉment_Stenac
It's not possible to disable meaning inference. Note that it only affects the display meaning, it does not actually change anything in the way the data is stored. See here: https://doc.dataiku.com/dss/latest/schemas/definitions.html for more information about meanings vs storage types.

You can force the meaning to "Text" (the 'default' meaning) on multiple columns (mass actions) on the schema screen in the dataset settings.
pyousefi
Level 2
Author
Thanks Clement. The Mass Action is what I did after filtering for boolean. When I download the dataset after inference, those columns that have been inferred, are replaced with true / false.
0 Kudos