Home
Table Tree
The Table Tree is an input specification for uploading tables to 1010data.
<links> (Top-level wrapper for links)
<links> can contain an arbitrary number of <link> tags, which act a wrapper used by the addtab transaction.

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.

`<links>` (Top-level wrapper for links)

<links> can contain an arbitrary number of <link> tags, which act a wrapper used by the addtab transaction.

Attributes

None

Contents

<links> can contain an arbitrary number of <link> tags, which act a wrapper used by the addtab transaction to create a persistent link between two tables along a set of columns or to bring some subset of columns from a second table into the base table. Its basic syntax is given as follows.

Example

<links>
  <link table2="foreign.table.name" col="col1,col2" col2="fcol1,fcol2" [denormalize="1"] />
</links>

This syntax specifies that the table referenced by the table2 attribute within the <link> tag should be joined along the columns indicated in the col and col2 attributes. If the denormalize attribute is present, columns from the foreign table are denormalized into the base table, otherwise a prelink between the two tables is generated. In the general case, any valid <link> operation that could be applied in the 1010data Macro Language can be included in the <links> block.