These are chat archives for frictionlessdata/chat
@nyurik i’m not sure i understand. You want to have columns that are null right? That is exactly what
missingValue definition is for. As the spec states http://specs.frictionlessdata.io/json-table-schema/#missing-values:
By “missing” we simply mean null or “not present for whatever reason”. Many datasets arrive with missing data values, either because a value was not collected or it never existed.
The missing value stuff is not about collation. If you are reading frictionlessdata/specs#97 we are addressing the second of two options that the Stiivi identifies:
Other use is to tell the analytical/datamining software which values are considered as empty (NULLs). For example a string field with a content string "NULL" or "(empty)" will be converted to real NULL value.