Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

Composite Keys

Composite Keys

Optionally, you can define a list of data holders as a composite key. To do this, nest multiple data holders under the
unique_fields
property.
Consider the following example:
<Persons> <Person ID="17" SubID="A">Bob</Person> <Person ID="17" SubID="B">Jane</Person> <Person ID="35" SubID="A">Larry</Person> </Persons>
Neither the
ID
attribute nor the
SubID
attribute identifies a
Person
element uniquely. The combination of
ID
and
SubID
, however, is a unique identifier. You can define
ID
and
SubID
as a composite key.


Updated September 26, 2018