...
The Object data type can be the basis for entire JSON files. When JSON files are formatted in a way that can be parsed by the the
| D s webapp |
|---|
| column1 | column2 |
|---|---|
| Texas | TX |
| New York | NY |
| California | CA |
For more information, see Working with JSON v2.
...
Depending on the use, it may be easier to work with your objects as String values. While Strings have no inherent structure, they do have a wide range of functions that you can use to find and extract information from the values. Some useful functions:
| Function | Description | ||||||
|---|---|---|---|---|---|---|---|
| FIND Function |
| ||||||
| RIGHTFIND Function |
| ||||||
| FINDNTH Function |
| ||||||
| SUBSTITUTE Function |
|
Unnest Objects
You can unnest the object data type to create new rows or columns based on the keys in the source data. The following example shows how to unnest object values into separate columns.
...
