Object Data Type

Contents:

Expand all Collapse all

Our documentation site is moving!

For up-to-date documentation of release 8.7 of Self Managed Designer Cloud, please visit us at https://help.alteryx.com/SMC/r87/.

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.