Home
Table Tree
The Table Tree is an input specification for uploading tables to 1010data.
<th> (Meta information for one column)
The metadata for a single column in a table.

Table Tree
The Table Tree is an input specification for uploading tables to 1010data.
- <table> (Top-level wrapper for table tree)
  The table tree is required and may have one attribute (name) and must contain certain elements.
- <title> (Table title)
  The title of a table. The table title identifies the table in the Insights Platform.
- <sdesc> (Short description of a table)
  The short description of a table from the table metadata.
- <ldesc> (Long description of a table)
  The long description of a table from the table metadata.
- <link> (Link header)
  The link header of a table. The link header is used to indicate which columns have come from a foreign table after it has been linked to another table.
- <maxdown> (Download limit)
  The maximum amount of data that can be downloaded at one time.
- <cols> (Metadata for all columns)
  The metadata for all columns in a table.
- <th> (Meta information for one column)
  The metadata for a single column in a table.
- <links> (Top-level wrapper for links)
  <links> can contain an arbitrary number of <link> tags, which act a wrapper used by the addtab transaction.
- <users> (Top-level wrapper for users)
  The users tree may have one attribute (type) and, depending on the value of that attribute, may contain multiple instances of the <user> element.
- <user> (User entry)
  The username or group name. The name provided must be a user or group that already exists in 1010data.
- <segmentation> (Specify the segmentation of a table)
  Specifies which columns should define the segmentation of a table.
- <sort> (Specify the sorting of a table)
  Specifies which column or columns on which the table should be sorted.
- <advise> (Specify segmentation relationships)
  Specifies how different columns are related in a segby or sortseg operation.
- <totals> (Table contains tabulation results)
  Indicates whether table contains results from a tabulation.
- <data> (Table data)
  The data in a table.
- <tr> (Data for one row)
  The data for a single row in a table.
- <td> (One cell of data in a table)
  The value of a single cell (column/row) of the table.

`<th>` (Meta information for one column)

The metadata for a single column in a table.

Attributes

Attribute	Value
`name`	The name by which the column is referenced in formulas and query operations Note: This is generally not the same as the column's heading (see "Contents" below). E.g., `street`.
`desc`	The description of the column
`format`	The display format for the data in the column Format specifications have the same form as is used in the XML Macro Language in the Edit Actions dialog of the 1010data web interface (e.g., `type:num;width:15;dec:2`)
`type`	The type of data in the column `type` must be one of: `i` (integer) `j` (big integer) (Available as of version 11.25) `f` (float) `a` (alphanumeric)
`index`	Whether or not the column is indexed. Valid values are 1 (indexed) or 0 (not indexed).
`fixed`	Indicates whether this is a fixed column or not. Valid values are 1 and 0. When `fixed` is `1`, this indicates that the column is a fixed column. Note: Fixed columns, when they exist in a table, are always visible and are separated from the other columns by a vertical orange line.
`total`	Indicates whether this is the result of a tabulation or not When `total` is `1`, this indicates that the values in the column are from the result of a tabulation.

name and type must be present; format is optional.

Contents

The column heading that appears above the column when the table is displayed in the 1010data web interface. Lines in the heading are separated by "
" (the newline character).

Example

<th name="date" type="i" format="type:date;width:8;dec:0" fixed="1">Date</th>
<th name="t0" type="f" format="type:num;width:6;dec:2" fixed="0" total="1">Average&#10;Dry Bulb&#10;Temp&#10;(Celsius)</th>