Page tree
Skip to end of metadata
Go to start of metadata

Description:

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.

IMPORTANT

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.

Default value:

blank - No values are converted to blank.

Scope:

  • 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:

Recommendation:

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.


  • No labels