Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. Appendix A: XML Datatype Reference
  10. Appendix B: XPath Query Functions Reference

XML Guide

XML Guide

Adding Columns to a View

Adding Columns to a View

You can add columns to an XML view inside the XML workspace. To add a column, select the column from the XPath Navigator.
You can add a column to an XML view when the following conditions are true:
  • The component path starts from the element in the schema that is the view root for that view.
  • The component is not an enclosure element.
  • The component does not violate normalization or pivoting rules. For example, you cannot add more than one multiple-occurring element to a view.
  • You can add mixed content elements as either simple or complex types.
  • Two views can share the same column, and a view might contain multiple identical columns.
To add columns to a view:
  1. Select an XML view in the workspace.
  2. Highlight a parent element in the Navigator that contains the components you want to add.
  3. Click Components > XPath Navigator.
    The XPath Navigator appears in the Navigator window.
  4. Click the Mode button and choose to add a column or a view row.
  5. Choose Advanced to add a pivoted column to the view.
    A pivoted column is an occurrence of a multiple-occurring element. You can add single-occurring columns in Advanced Mode.
    You cannot create pivoted columns in XML target definitions.
  6. Drag a column from the XPath Navigator to the appropriate view in the XML workspace. You can select multiple columns at a time.
    The XML Editor validates the column you add. If the column is invalid for the view, a message appears in the status bar while you are dragging the column. New columns display as you add them to views.

0 COMMENTS

We’d like to hear from you!