XML Guide

10.5.6
- 10.5.7
- 10.5
- 10.4.0

Back Next

Adding a Pivoted Column

A pivoted column in an XML definition is a multiple-occurring element that forms separate columns for the element occurrences in a view. You can create pivoted columns from any multiple-occurring element in an XML definition. You can also pivot elements in a view row.

If you add a pivoted column to a view, a default occurrence number appears in the Columns window. This number indicates which occurrence of the element to use in the column. You can change the occurrence number or add more occurrences of the element as new columns. If you do not rename the columns, the XML Editor adds a sequence number to each pivoted column name.

You cannot change a pivot value if the pivot value is part of a view row.

To add a pivoted column to a view:

Select the XML view in the workspace.

Highlight the element in the Navigator that you want to pivot.

Or, highlight any element in the parent chain of the element that you want to pivot.

Click Components > XPath Navigator.

Select Advanced Mode.

Drag the column to pivot from the XPath Navigator to the view in the XML workspace.

The Designer adds a default occurrence number in the Columns window. This number indicates which occurrence of the element to use in the column.

In the following figure, the view contains two occurrences of Sales for the third occurrence of Product: