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. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Creating an XML View

Creating an XML View

You can create views in the XML workspace. When you create an XML definition with no views, the XML Editor displays an empty workspace. You can create a view and add the columns and the view row to the view.
To create a new XML view in the workspace:
  1. Open the XML definition in the XML Editor.
  2. Click XML Views > Create XML View.
    The XML Editor creates a blank view in the workspace and displays empty columns in the Columns window.
  3. Enter a name for the view in the Columns window.
    The name appears on the XML view in the workspace.
  4. Highlight the node in the Schema Navigator from which you want to create a view.
  5. Click Components > XPath Navigator.
    The XPath Navigator appears in the Navigator window.
  6. Set the Column Mode in the XPath Navigator to View Row Mode to add the view row.
  7. Select the element in the Navigator and drag the element to the view in the workspace.
    The XML Editor highlights the view row in blue.
    The first time you add a column to a view, the Designer verifies the column can be a view row. This occurs even if you do not specify to add a view row.
  8. To change the view row to another column, right-click the appropriate row in the view and choose Set As View Row.

0 COMMENTS

We’d like to hear from you!