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.

Var denne siden nyttig? Si fra hva du synes:

Send tilbakemelding om ...

Google Cloud Dataprep Documentation
Trenger du hjelp? Gå til brukerstøttesiden vår.