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 |