TenDo lets you add the results of a query to an existing 1010data table.
TenDo provides functionality for both appending query results to an existing table, as
well as appending multiple tables already on the server. Let's look at the syntax for
Note: In order to append tables to one another, all tables must have the same exact column
Appending query results to an existing table
To add the results of a query to an existing 1010data table, simply use the
operator instead of the regular =
from the previous example. For
$ tendo -u [USERNAME] [FOLDER].[EXISTINGTABLENAME]+=[TABLE] @[QUERY]
not insert spaces around the plus-equals (+=) sign.
command takes the results from a query on a base table and appends those results to
a table that already exists in 1010data. The existing table can be any table you
have permission to write to, or the base table itself.
Appending existing 1010data tables
As in the 1010data Insights Platform, you can append existing tables to one another.
This is done very simply with the +
$ tendo -u [USERNAME] [NEW_TABLE]=[TABLE1]+[TABLE2]+[TABLE3]+...[NthTABLE]
not insert spaces around the equals sign (=) or plus signs
This command creates a new table that contains
the data from table 1 through the Nth table, in the order that they were passed to