Skip to content

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.

CommandDescription
Clean TableDeletes empty records, that is a record where number field is '0' and every text field is empty.
Clear TableDeletes all records of a table.
Create TableCreates a table.
Create Table DimensionAdds a dimension to a table. The table must be empty.
Create Table DoubleCreates a number field in the table.
Create Table StringCreates a text field in the table.
Delete TableDeletes one or multiple tables.
Delete Table DimensionRemoves one or multiple dimensions from a table. The dimension is not deleted. The table must be empty.
Delete Table DoubleDeletes one or multiple number fields from a table.
Delete Table StringDeletes one or multiple string fields from a table.
Edit TableEdits a table.
Edit Table DoubleChanges the name of a number field of a table.
Edit Table StringChanges the name of a string field of a table.
Export TableExports a table to a text file. The text file is saved on the server.
Import TableImports a table from a text file. The text file is loaded from the server.
Move Table DimensionMoves a dimension of a table up or down. The table must be empty.
Move Table DoubleMoves a number field of a table up or down.
Move Table StringMoves a text field of a table up or down.
Set Table VisualSets the visual script of a table.
Show TableShows a table.
Show Table FieldsShows the table fields.
Show Table FilledShows 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 ItemsShows the table items without fields.
Show Table StructureShows the table structure. The amount of nodes per dimension and the average amount of items per node.
Show Table TreeShows the tree items of a table. Number or text fields are not shown.
Show Table VisualShows the visual script of a table.
Show TablesShows the tables.