Appending tables

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 each instance.

Note: In order to append tables to one another, all tables must have the same exact column format.

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 = operator from the previous example. For instance:
$ tendo -u [USERNAME] [FOLDER].[EXISTINGTABLENAME]+=[TABLE] @[QUERY]
Note: Do not insert spaces around the plus-equals (+=) sign.
This 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 + operator, as follows:
$ tendo -u [USERNAME] [NEW_TABLE]=[TABLE1]+[TABLE2]+[TABLE3]+...[NthTABLE]
Note: Do 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 TenDo.