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 |