Home
Table Tree
The Table Tree is an input specification for uploading tables to 1010data.
<advise> (Specify segmentation relationships)
Specifies how different columns are related in a segby or sortseg operation.

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.

`<advise>` (Specify segmentation relationships)

Specifies how different columns are related in a segby or sortseg operation.

Attributes

Attribute	Value
`<cols>`
`<sort>`	Either 0 for segby or 1 for sortseg

Contents

<advise> is used within the <segmentation> tag to establish a relationship between the segmentation of two columns.

Example

<segmentation cols="col1,col2" [advise="0"]>
  <advise [sort="1"] cols="col1,col3"/>
</segmentation>

The <segmentation> block can contain an arbitrary number of <advise> tags. Each advise tag indicates that a particular sequence of columns is also sortseg or segby, given the segmentation enforced in the <segmentation> tag’s cols attribute. For example, if you have your table segby "day", then it is probably also segby "month". If for some reason you want to enforce segmentation by a particular column (or columns), but not to include it in the list of advised columns the "advise=0" attribute may be included in the <segmentation> tag.