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. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

Creating an XML Lookup Table Dynamically

Creating an XML Lookup Table Dynamically

A transformation can create an XML lookup table at runtime. For example, the transformation might run a secondary Parser that generates the XML structure.
The transformation must store the XML string in a multiple-occurrence data holder of type cde:lookupTable. Store each key-value pair in an occurrence of the data holder. For example, you might configure a
RepeatingGroup
containing a
WriteValue
action. Each iteration of the
RepeatingGroup
creates an occurrence of the data holder and writes a key-value pair to the occurrence.
Then configure a
LookupTransformer
with the
DynamicTable
option, and specify the data holder.
level 1 MyLookup = LookupTransformer >> level 2 look_at = DynamicTable level 3 table = $LookupTable level 1 LookupTable = Variable >> level 2 val_type = cde:lookupTable


Updated September 26, 2018