Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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.

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.

Your Rating: Results: PatheticBadOKGoodOutstanding! 4 rates

This page has no comments.