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

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