Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Table Functions - append

Table of contents
  • append TableName

Append new table to the current table. The new table should have the same columns as the current table.

Example:

function example1() {
    search {from="-10h", to="-3h"} sContent("@tags","fpl-example-data")
    let {id, isx5, isprime, odd, even, divisors} = f("@fields")
}

function example2() {
    search {from="-1h"} sContent("@tags","fpl-example-data")
    let {id, isx5, isprime, odd, even, divisors} = f("@fields")
}

stream demo_table1=example1()
stream demo_table2=example2()

append demo_table1

In the example above, “demo_table1” and “demo_table2” have the same columns. Before the sentence append demo_table1, the current table is “demo_table2”. The command append appends “demo_table1” to “demo_table2”.