Show attributes in rows and columns

Worksheets can show attributes in rows and columns. To show attributes in rows and columns, add the appropriate worksheet column headers from the Attribute Columns and the Attribute groups when you retrieve elements.

1. Select the attributes to show in columns:

   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.

2. Set the worksheet to show attributes in rows:

   1. From the Object Types list, expand the Attribute group.

   2. Select the attribute-specific columns that you want to include in the worksheet, such as value, type, and so on. See List of attribute-specific column headings.

      Alternatively, to show attributes in rows but not include any attribute-specific columns, select the Attribute group check box and clear the check boxes for the attribute-specific columns. When the Attribute group check box is selected, PI Builder shows attributes in rows.

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. The worksheet contains the selected attribute columns and also writes attributes in separate rows.