Step 2: define the pseudo table

Click Add pseudo table icon  to add a new pseudo table.

There is pseudo.zip file under【esProc installation directory】\ esProc\documents\en. The file stores composite table files used in DQL Tutorial. Just decompress it for use.

Click Select to select the decompressed composite table file emps.ctx. The system automatically recognizes and uses emps as the pseudo table name, and list the composite table’s fields and primary key under Select field(s):

Click Save button to save the pseudo table definition to the metadata file. The file name is demo.glmd.

The example composite table file (emp.ctx) has fields such as EID, DeptID, Gender, Married, Name, as well as a Bools field that store Gender and Married fields together. Below is the composite table’s data:

About generating the original composite tables, see Pseudo Table: Basic uses in esProc Tutorial.