Modify a column

You can rename a column, set a calculation such as an average on the values in the column, change the data type, change the unit of measure, or remove the column.

1. Click on the column to open the Column Details panel.

• The PI Integrator Framework reserves the case-insensitive strings, ID, PIIntTSTicks, and PIIntShapeId, as column names. You may use these strings to name columns in your asset and event views. However, if you do, an underscore (_) is appended to the column name in your target data, for example, ID_ or Id_.

  Note: This restriction does not apply to the following targets: Amazon Kinesis Data Streams, Amazon S3, Apache Kafka, Azure Event Hubs, Azure IoT Hub, Google Cloud Storage, Google Pub/Sub, Hadoop Distributed File Storage, and Text File.

• Column names are reformatted based on the limitations of each target store. For example, Oracle column names are limited to 30 characters and column names longer than 30 characters are truncated.

• The Oracle database targets have reserved strings; if these strings appear in the column names, an underscore (_) is appended to the string.

• Column names must be unique.

• The Last Recorded Value function in the Data Content field is used with data that should not be interpolated, for example, a status attribute that is either on or off. Last Recorded Value looks back in time and returns the most recent value of the change in the status attribute.

  

  2. Make any changes to the column.

  3. When you are done, click Apply Changes.