Understand null values

If you publish an empty cell for an attribute with a value type that accepts null values, PI Builder sets the value to null.

PI Builder can set values to null for attributes and attribute templates when the value type accepts null values. To set a value to null, clear the value in Microsoft Excel and then publish the object to PI AF.

If you publish an object with an empty cell and the value type for the object does not accept null values (including arrays), PI Builder does not make a change; it ignores the empty cell.

The following value types accept null values:

• Anything

• Element

• Attribute

• Enumeration set

• String

For strings, the new value will be the empty string ("").