Array Data Type

An array is a list of values grouped into a single value. An array may be of variable length; in one record the array field may contain two elements, while in the next record, it contains six elements.

Arrays must be wrapped in square brackets; parentheses are not supported.

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.

Examples:

["123","456","789"]
["Hello","Goodbye"]
["abc","2"]
["abc","3"]
["A",["B","C"],"D"]

Ragged arrays: The above arrays are collectively a set of ragged arrays. The number of elements in each array varies. When arrays are ragged, some array functions may return null or empty values.

Nested arrays: The last example above is a nested array, in which one array is nested inside of another.

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

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation
Need help? Visit our support page.