You can right click anywhere in the table title bar or click the triangle in the lower-right corner of the table title bar to display a drop-down menu. The menu presents table options for manipulating the entire table. This section explains the purpose of each table option.
You can hide a table that you rarely use. The hidden table does not show up in the worksheet, but you can add it back at any time. For more information about adding a hidden table back to the worksheet, see Changing a table to an active table.
You can minimize a table to significantly decrease the table width. You cannot view table columns in a minimized table, but the table remains visible in the worksheet, enabling you to click the table title bar to display the table options. One of the options is Maximize table, which returns the minimized table to its full size.
You can drop a table you no longer need. Dropping a table removes it from memory.
You can export a table or selected columns of a table to a default export target or a user-defined export target.
Publish to Jupyter
You can publish a table or a partial table to a notebook. Then you can use Jupyter for data analysis or visualization for the published rows. For information about publishing a table to a notebook, see Publishing data from a table to a notebook.
Smart type casting
You can change the data type for one or multiple columns. For more information about smart type casting, see Changing the data type of a column.
If you have multiple tables in the worksheet, you can move the table to the left or to the right.
If you have multiple worksheets in the workbook, you can also move the table to a different worksheet.
You can arrange table columns by name, type, and prefix. The following list describes how Xcalar Design compares strings when sorting by name or prefix:
If strings end with a non-numeric value, they are sorted in ASCII order. For example, the following strings are sorted in ascending order:
If strings end with a numeric value, they are sorted in ASCII order for the alphabetical portion and then numerically for the ending numeric portion. For example, the following strings are sorted in ascending order:
Sort columns by name
You can arrange table columns by sorting the column names.
The following list shows how column names are ordered in ascending order:
Sort columns by type
You can arrange table columns by sorting the columns' data types. For each data type, the columns are sorted by name. If you sort in ascending order, derived fields are placed before prefixed fields.
The following list shows how data types are ordered in ascending order:
Sort columns by prefix
You can arrange table columns by sorting the prefixes. Columns with the same prefixed are sorted by name. If you sort in ascending order, derived fields are placed before prefixed fields.
The following list shows how prefixed fields and derived fields are ordered in ascending order:
Resize all columns
You can resize all columns at once. For more information about resizing a column, see Resize.
You can display the Correlation And Quick Aggregates modal window from this option. For more information about correlations and aggregates, see Determining correlation between two values.
Create batch dataflow
For each active table in the worksheet, you can create a batch dataflow. This option enables you to perform the same task as described in Creating a batch dataflow
The advanced options provide a shortcut for these tasks that you can also accomplish through a table icon in a dataflow graph:
- locking a table
- unlocking a table
- generating a table with only erroneous rows
- generating a complement table
For information about these tasks, see Tasks you can perform by clicking the table icon
In addition, an advanced option called View skew details displays a modal window that shows how evenly the data in the table is distributed across the cluster nodes. This modal window is the same as the one displayed when you click Skew to the right of the function bar in the worksheet window. For information about skew, see Skew value.