| D toc |
|---|
| Excerpt | ||||
|---|---|---|---|---|
This section describes how to work with the Array data type in the
|
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
...
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
...
- nested array. See the last example above.
For more information, see Array Data Type.
...
| arrayNested | arrayNested_1 | arrayNested_2 |
|---|---|---|
| ["A",["B","C"],"D"] | ["B","C"] | B |
| ["H",["I","J",["K","L"]]] | ["I","J",["K","L"]] | I |
| ["E","F","G"] | F |
| D s also | ||||
|---|---|---|---|---|
|
