Object Data Type

Contents:

Expand all Collapse all

Scheduled Maintenance: docs.trifacta.com will be offline for maintenance at 3:00pm UTC on Thursday March 30 for about 15 minutes.

An Object data type is a method for encoding key-value pairs. A single field value may contain one or more sets of key-value pairs.

An Object data type is identified as a set of nested objects in the following format:

{"key":"value"}
{"New York":"NY"}
{"California":"CA"}

Notes:

Individual values of an Object type must have unique keys. Values, however, may be repeated.
The order of key-value pairs is not guaranteed.
The maximum size of an Object is determined by the maximum size of a cell's value in the data grid. For more information, see Data Grid Panel.

NOTE: The Designer Cloud application recognizes up to 250 unique keys in a column of Object data type.

NOTE: The \n and \t escaped characters are supported in inputs for this data type. For more information, see Supported Special Regular Expression Characters.