Set column headers in a worksheet

Use the Select Object Types and Column Headers window to specify the column headers and order in your worksheet. When configured in the retrieve settings, this window automatically opens when you retrieve data. You can also click Headers to add columns to the worksheet before retrieving or publishing data, or to rearrange columns in an existing worksheet without overwriting the worksheet.

1. Open the Select Object Types and Column Headers window.

   You can:

   • On the PI Builder tab, in the Resources group, click Headers.

   • Retrieve data. With the default retrieve settings, the Select Object Types and Column Headers window opens after you specify the objects to retrieve.

2. From the Object Type list, select the type of AVEVA™ PI System™ object that you will retrieve into the worksheet.

   The Object Types list updates to show possible columns for the selected PI System object type. Selected columns and order are based on the current worksheet or previous selections. For a list of columns, see Overview of column references.

3. To restore the default column order, click Reset.

4. To clear all column selections, click Clear All.

5. Select the check boxes next to the columns that you want to appear in your worksheet.

   The Object Types list does not automatically contain all the attributes that you can show in columns. To add attribute columns to the list of available columns, you can:

   • From the Template list, select the template on which retrieved objects are based.

     The Object Types list updates the available attribute columns to show those in the selected template.

   • Click More Attribute Columns to open the Select Attributes window, and specify attributes to add:

     • Select attributes from a template.

     • Select attributes from a particular instance of a PI System object, such as customized attributes not from a template.

     • Type the attribute name in the Others field and click Add.

   Note: You must include the ObjectType column, unless using a worksheet created with PI Tag Configurator.

6. To change the column order, select a column and click the up or down arrow.

7. Click OK to apply the changes to the worksheet.

   PI Builder updates the existing worksheet content to reflect the changes:

   • If you opened the window during data retrieval, PI Builder retrieves available data into the selected columns.

   • If you opened the window independently, PI Builder does not retrieve data into any columns, including newly added columns; click Retrieve to update data and retrieve data into newly added columns.