| 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 nested
...
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
...
- array. See the last example above.
For more information, see Array Data Type.
...
| msg | acronyms |
|---|---|
| SCUBA, IMHO, is the greatest sport in the world. | ["SCUBA","IMHO"] |
| [] | |
| LOL, that assignment you finished is DOA. You need to fix it PDQ. | ["LOL","DOA","Y","PDQ"] |
...
| 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 | ||||
|---|---|---|---|---|
|
