Skip to main content

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

IDCityStateCountry
1RockvilleMarylandUS
2Silver SpringMarylandUS
3BaltimoreMarylandUS

Table t2

IDCityStateCountry
4SeattleWashingtonUS
5BellevueWashingtonUS
6SpokaneMarylandUS
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

IDCityStateCountry
1RockvilleMarylandUS
2Silver SpringMarylandUS
3BaltimoreMarylandUS
4SeattleWashingtonUS
5BellevueWashingtonUS
6SpokaneMarylandUS