Create table column definitions

To create a table manually, begin by defining the columns in the table.

1. Once you have completed the overall table settings on the General tab, click the Define Table tab.

2. Determine the number of columns in the table and click once for each column to be defined.

3. Click the Name cell and replace the default label with the required column name.

4. Click the adjacent Value Type cell and select a data type from a list of Basic Types or Array Types. For a description of data types, see List of data types.

   Tip: If any value type is set to DateTime or String, leave the column time zone value set to None and select a time zone value for the table overall in the Time Zone field on the General tab. That value supersedes time zones set on specific table columns.

5. Optional. Click the Unit of Measure cell and choose one of the following actions:

   • Start typing and select a unit of measure from the list of matching UOMs.

   • Click and select from the full list of UOMs.

   Tip: We recommend you set a unit of measure for a table column so you do not need to specify one each time you select the column in a table lookup data reference.

6. Optional. For any column you assign a Byte Array value type, you can set Use Image to True. PI System Explorer attempts to display the array as an image.

7. Repeat steps 3 to 6 for each column in the table.

8. To modify the table column definition, right-click a row in the grid and select an option. Alternatively, use the following icons.

   To ...	Do this ...
   Insert a new column	Click .
   Move a column up a row	Select a row below the top row and click .
   Move a column down a row	Select a row above the bottom row and click .
   Remove a column	Select a column and click .

When you have completed defining table columns, click the Table tab so you can enter row data for each column manually.