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

Pivoted Relational Input

Pivoted Relational Input

You can include a specific number of multiple-occurring elements in an output group.
To pivot multiple-occurring elements, map the multiple-occurring port element to specific output nodes.

Pivoted Relational Input Example

You want to transform relational input that contains a table of telephone numbers to an XML hierarchy with separate elements for different types of telephone numbers.
In the relational input, the Telephone_type element defines the type of phone number listed for each person:
Telephone_Number
Telephone_Type
Last_Name
First_Name
9173327437
Mobile
Sandrine
Jacques
9174562342
Mobile
Race
Tom
8484526471
Home
Race
Tom
7023847265
Work
Smith
Delilah
9174596725
Mobile
Smith
Delilah
In the Telephones output XML hierarchy, different types of telephone numbers in the parent group have separate elements:
Telephones
Telephone_Number Last_Name First_Name Work_Telephone Mobile_Telephone Home_Telephone


Updated June 14, 2019