Qlik Data Catalyst supports population of custom source, entity, and field (column) property values through Excel spreadsheet import.
Note that each additional custom property added in the spreadsheet must also correlate to a pre-created custom source, entity, or field property in Qlik Data Catalyst (user-created custom property—for PUT/propDef/v1/save payload examples, refer to this section: Sample Payloads for Custom Properties: PUT /propDef/v1/save). The values for the custom properties will be mapped to the correct object-level(s) in the spreadsheet (i.e., If source and entity names are provided in the spreadsheet, and the entity level property has been created, the value will be inserted at the entity property).
As in the case of regular Business Metadata Import, a few rules apply:
- Values must be entered for Business Name columns in the spreadsheet: null values for these fields are not allowed.
- Values must be entered for every existing parent object level (i.e., entity-level properties must specify Source and Entity, Field-level properties specify Source, Entity, Field).
- Custom Business Metadata columns must appear in columns to the left of the Tags columns.
Upon upload the values in the XLS spreadsheet are imported and display at the appropriate custom property level.
Values display on the Properties Modal for the defined Source, Entity, and Field level for this example.