This property specifies string values that can be interpreted as a blank value. This allows a “non-date” field of 01/01/1900 to be treated as blank, or a “-” or “NA” to be treated as blank.
Values and behavior:
Blank Strings - When “Blank” or “Strings” is found in a DATE or NUMBER type field, they will be changed to blank fields. Each possible value should be separated by a comma.
The property does not support strings containing commas, as they are considered separate strings. For example, the string "Los Angeles, CA" is treated as two strings - Los Angeles and CA, rather than a single string.
blank - No values are converted to blank.
- Registered File: If the property is set on a for a particular registered file, then the value will be applicable for a particular file, and will override the value applied (if any) at the connection.
- Cube: If the property is set on a cube, then the value will override the connection level value for that cube’s build job.
- Dataset: If the property is set on a dataset, then the value will override cube level value for that cube’s dataset build job.
NOTE: If the property is set on a dataset and a dataset is built, then the value will override the connection level value for that dataset build job.
Comes into effect:
The property is applicable at build time. The value specified in the property is used while building the dataset and cube.
Dependencies and related properties:
Once the number or date type field has been converted to a blank, the properties, kyvos.date.blank.default and kyvos.number.blank.default will also be applied. This provides the ability to change “NA” to a 0, by setting property kyvos.records.values.assumeasblank to NA and kyvos.number.blank.default to 0.