Description:

This property specifies the default date value for a DATE type column when the value is blank in the underlying data. When a value is set for this property, an empty value will not invalidate a row.

Values and behavior:

Any date string in MM/DD/YYYY format.

Default value:

Blank

Scope:

• Connection: If the property is set at the connection, then the property value is applicable for all dataset build and semantic model jobs.

• Semantic Model: If the property is set on a semantic model, then the value will override the connection level value for that semantic model’s job.

Comes into effect:

The value of the property can be changed at any time (not recommended) and comes into effect in the next build.

Dependencies and related properties:

• Semantic Model: kyvos.records.skipbadrows

• Semantic Model: kyvos.records.skipbadrows.threshold

• Semantic Model: kyvos.number.blank.default

Recommendation:

In cases where data has date values in a different format, specify the property value in MM/DD/YYYY format, and Kyvos will automatically convert it to the correct field format.