Worksheet window with tables
This section provides an overview of the Worksheet window that contains tables. The exact contents of the Worksheet window depend on your tables and might be different from the window contents described in this section.
The following screenshot explains the purpose of each user interface element in a worksheet containing one table.
The column prefix in this example has a green background color. You can display a list of colors and choose a desired color, as shown in the following partial screenshot.
At the top of the worksheet window, a skew value is displayed for the table you are currently working on. The value is an indicator for how evenly data in the table is distributed across the nodes. The value ranges from 0 to 100. If it is 0, data is perfectly distributed across all nodes. If it is 100, all data is on one node.
To see how data is distributed, click Skew. A modal window is displayed to show detailed information related to data distribution.
Menus displayable in the worksheet
Several menus can be displayed when you view a worksheet containing one or multiple tables.
Column drop-down menu
You can start most of the data operations from the column drop-down menu. The exact options in this menu depend on the column's data type. To display the menu, you can right-click the column header or click the triangle in the lower right corner of the column header. For simplicity, Xcalar Design documentation instructs you to right click the column header to display the menu. The following partial screenshot shows an example of the column drop-down menu.
Cell pop-up menu
You can right click on a table cell to display a pop-up menu. The exact options in this menu depend on the column's data type. The following partial screenshot shows an example of a cell pop-up menu. The options in this menu are explained in Cell options.
Table drop-down menu
You can start operations that affect the entire table from the table drop-down menu. To display this menu, click anywhere in the title bar of the table (but not on the table title) or click the triangle in the lower right corner of the table title bar. For simplicity, Xcalar Design documentation instructs you to click the table title bar. The following partial screen shows an example of the table drop-down menu. The options in this menu are explained in Table options.