Show attributes in columns

Worksheets can include columns for attributes. The names of these columns contain the attribute path preceded by a pipe symbol (|). Cells in an attribute column show the attribute value or the attribute-configuration string (see Understand how to view data references) in the row of the attribute's parent element. To show attributes in columns, add the appropriate worksheet column headers from the Attribute Columns group when you retrieve elements.

Prerequisite: Select an element or elements to retrieve and open the Select Object Types and Column Headers window:

• Retrieve all elements

• Retrieve elements by browsing

• Retrieve elements by searching

1. In the Select Object Types and Column Headers window, from the Object Types list, expand the Attribute Columns group.

   The list shows available attributes ordered by template. If necessary, you can select a different template from the Template list to show attributes from that template.

2. Select the attributes that you want to include as columns in the worksheet.

3. Select any other columns you also want to include in the worksheet.

4. Click OK.

   PI Builder adds the selected column headers to the worksheet and retrieves the previously selected elements. Each selected attribute appears as a column in the worksheet; the name of each column is the attribute path (see Understand child attributes). The cells in these columns contain the attribute values, though a data reference attribute can contain either a value or the attribute configuration string (see Understand how to view data references).