Table
jsonTable
- jsonTable(array)
- generate a table from a literal array expression
let arr = [
{ID: "a", Col1: "x"},
{ID: "b", Col2: "y"}
]
let t = jsonTable(arr)
mergeTable
- mergeTable(table1, table2..)
- generate a new table by merging input tables
Table t1
| ID | City | State | Country |
|---|---|---|---|
| 1 | Rockville | Maryland | US |
| 2 | Silver Spring | Maryland | US |
| 3 | Baltimore | Maryland | US |
Table t2
| ID | City | State | Country |
|---|---|---|---|
| 4 | Seattle | Washington | US |
| 5 | Bellevue | Washington | US |
| 6 | Spokane | Maryland | US |
let t3 = mergeTable(t1, t2) // t3 is a new table with data from t1 followed by t2
Table t3 resulting from the mergeTable function call
| ID | City | State | Country |
|---|---|---|---|
| 1 | Rockville | Maryland | US |
| 2 | Silver Spring | Maryland | US |
| 3 | Baltimore | Maryland | US |
| 4 | Seattle | Washington | US |
| 5 | Bellevue | Washington | US |
| 6 | Spokane | Maryland | US |