Table of Contents

Search

  1. Preface
  2. Introducing Reference 360
  3. Getting started with Reference 360
  4. Manage system reference data
  5. Manage reference data sets
  6. Manage code lists
  7. Manage code values
  8. Manage crosswalks
  9. Import data
  10. Manage hierarchies
  11. Manage attributes
  12. Manage workflows
  13. Manage jobs
  14. Reference 360 REST API
  15. Glossary

Reference 360

Reference 360

Import related code values into a hierarchy

Import related code values into a hierarchy

You can import related code values into a hierarchy in
Reference 360
.
For example, a location hierarchy is defined with two parent-child relationships between the Country to State code list and State to State Code code lists. If you want to import 1000 related code values into a hierarchy, you can import the source file that contains the required relationship details with the parent and child code values.
The source file that you import must contain the code values of the parent and child code lists.
Reference 360
generates the source primary key of relationships with the related parent and child code values. To import the code values, map the source primary key fields from your source file to the target fields.
You can't update existing relationships in a hierarchy because each relationship contains source primary keys with unique codes of the parent and child code values.
The following table lists a sample format of the source primary keys of the relationships along with the related parent and child code values:
TopLevel_spkey
CountrytoState_parent
CountrytoState_child
StatetoStatecode_parent
StatetoStateCode_child
Germany
Germany
Berlin
Berlin
10243
India
India
Delhi
Delhi
110010
Australia
Australia
Sydney
Sydney
2001
The import process verifies the mapping and ensures that the source file contains the same relationships and code values that exist in the hierarchy model. If the source file contains different relationships and code values, the import process fails.

0 COMMENTS

We’d like to hear from you!