Reset CTX Table

The item lets you rearranges a composite table to generate a new composite table file.

Example: Split composite table emp.ctx into two zone tables according to different GENDER values.

Click CTX -> Reset to enter the following interface, where you check Split the ctx table to multiple zone tables and set up Zone Table Expression and Number of Zone Tables:

Is zipped file: Set whether to use a data compression technique to store the composite table.

Store by row: Set whether to store data row-wise. By default, use the column-wise storage.

Quick reset: Set whether to reset the composite table quickly.

Split the ctx table to multiple zone tables: Set whether to split the current composite table into multiple zone tables.

Zone Table File Name: Set zone table file name, which consists of zone table number and zone table name, like “1.zone table name.ctx”.

Zone Table Expression: Edit a zone table expression.

Number of Zone Tables: Specify the number of zone tables you want to divide the composite table into. This item specifies the number of zone tables into which the composite table will be divided. It should be consistent with the number of zone tables specified in Zone Table Expression.

Click Execute to get the following zone tables: