Document toolboxDocument toolbox

Semantic Model: kyvos.sync.rows.mismatchcolumns

Description:

This property specifies how to handle instances where the number of columns defined in the Kyvos Registered File is different from the number of columns in the raw source file. Kyvos will first fix the number of columns by adding blank columns at the end of the row or removing columns from the end of the row. Once fixed, the data load process will continue.

Values and behavior:

  • true - The row with an incorrect number of columns will be fixed to sync the columns as per raw data.

  • false -The row with an incorrect number of columns will be skipped as invalid.

Default value:

False

Scope:

  • Connection: If the property is set at the connection, then the property value is applicable for all dataset build and semantic model process 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 process jobs

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:

Recommendation:
This property only looks at the number of columns. Data type conflicts and incompatibilities are still possible. Apply this property to a semantic model when launching a process job.

Copyright Kyvos, Inc. All rights reserved.