Check out Building a Data-Centric Culture at the ALMA Observatory on November 5th Read More

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

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
Dataiker
Dataiker
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.
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
Labels (1)