Appearance
Command Group - Table
Tables, or cubes, are the primary containers for multidimensional data. This group contains commands for managing table structures, data import/export, and metadata inspection.
| Command | Description |
|---|---|
| Clean Table | Deletes empty records, that is a record where number field is '0' and every text field is empty. |
| Clear Table | Deletes all records of a table. |
| Create Table | Creates a table. |
| Create Table Dimension | Adds a dimension to a table. The table must be empty. |
| Create Table Double | Creates a number field in the table. |
| Create Table String | Creates a text field in the table. |
| Delete Table | Deletes one or multiple tables. |
| Delete Table Dimension | Removes one or multiple dimensions from a table. The dimension is not deleted. The table must be empty. |
| Delete Table Double | Deletes one or multiple number fields from a table. |
| Delete Table String | Deletes one or multiple string fields from a table. |
| Edit Table | Edits a table. |
| Edit Table Double | Changes the name of a number field of a table. |
| Edit Table String | Changes the name of a string field of a table. |
| Export Table | Exports a table to a text file. The text file is saved on the server. |
| Import Table | Imports a table from a text file. The text file is loaded from the server. |
| Move Table Dimension | Moves a dimension of a table up or down. The table must be empty. |
| Move Table Double | Moves a number field of a table up or down. |
| Move Table String | Moves a text field of a table up or down. |
| Set Table Visual | Sets the visual script of a table. |
| Show Table | Shows a table. |
| Show Table Fields | Shows the table fields. |
| Show Table Filled | Shows how many of the table fields are filled, that is number fields that are not '0' and text fields that are not empty. |
| Show Table Items | Shows the table items without fields. |
| Show Table Structure | Shows the table structure. The amount of nodes per dimension and the average amount of items per node. |
| Show Table Tree | Shows the tree items of a table. Number or text fields are not shown. |
| Show Table Visual | Shows the visual script of a table. |
| Show Tables | Shows the tables. |