Show attributes in rows
- Last UpdatedJan 11, 2023
- 1 minute read
- PI System
- PI Server 2018
- PI Server
Worksheets can include rows for each attribute of an element. To show attributes in rows, select the Attribute group when you retrieve elements into the worksheet.
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
-
In the Select Object Types and Column Headers window, from the Object Types list, expand the Attribute group.
-
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.
-
Select any other columns you also want to include in the worksheet.
-
Click OK.
PI Builder adds the selected column headers to the worksheet and retrieves the previously selected elements. The attributes of the retrieved elements appear in rows in the worksheet.