| D toc |
|---|
| D excerpt | ||||
|---|---|---|---|---|
This section describes how to work with the Array data type in the
|
...
a set of delimited values. Any individual value in the list can be a separate array, which allows for the creation of nested data arrays. |
Array Types
To be recognized as an array, a source column must contain values that are:
- Bracketed by square brackets
- Values in cell are delimited by commas
Such columns are likely to be recognized as Array data type.
The following are valid arrays:
| Code Block |
|---|
[1,2,3] ["A","B"] ["C",["D","E"],"F",["G",["H","I"]]] |
- Ragged arrays: If the number of elements varies between two arrays, they are considered ragged. In the above, all three arrays have a different number of top-level elements (3,2,4).
- Nested arrays: When an array element is an array itself, the element is considered a nested array. See the last example above
...
Source Arrays
To be recognized as an array, a source column must contain values that are:
- Bracketed by square brackets
- Values in cell are delimited by commas
...
- .
For more information, see Array Data Type.
...
