Table options

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.

Hide table

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.

Minimize 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.

Drop table

You can drop a table you no longer need. Dropping a table removes it from memory.

NOTE: You cannot undo the action of dropping a table.

Export table

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.

Move

If you have multiple tables in the worksheet, you can move the table to the left or to the right.

TIP: Alternatively, you can move the cursor to anywhere in the table title bar. When the cursor changes into the Hand icon, grab and drag the table to the desired location.

If you have multiple worksheets in the workbook, you can also move the table to a different worksheet.

Sort columns

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: 

    • 1DayOfWeek
    • Carrier
    • Dep1Time
    • Dep2Time
  • 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:

    • 3column
    • column1
    • column2
    • column10
NOTE: To move a particular column without sorting, simply move the cursor to the column header. When the cursor changes into the Hand icon, grab and drag the column to the desired location.

Sort columns by name

You can arrange table columns by sorting the column names.

NOTE: Prefix names are not considered in the column name sort.

The following list shows how column names are ordered in ascending order:

  • AirTime_integer
  • airlines::Carrier
  • DayOfWeek_integer

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:

  • Boolean
  • Float
  • Integer
  • String

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:

  • ArrTime_integer
  • DayOfWeek_integer
  • airlines::Carrier
  • airlines::DepTime
  • myairlines::AirTime
  • myairlines::TaxiOut

Resize all columns

You can resize all columns at once. For more information about resizing a column, see Resize.

Correlation

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

Advanced Options

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.

Go to top