Understanding and changing table statuses

A table can have an active, hidden, or temporary status. You can change the status of a table in multiple ways.

Tables consume memory regardless of their status. To determine how much memory each table uses, see Understanding memory usage.

Viewing the tables list

To display the tables list, follow these steps:

  1. Click (Worksheet icon).
  2. In the Worksheet panel, click to display the Tables panel, which displays the names of all tables in the workbook. Use the Active, Hidden, and Temporary tabs to display tables based on their status.

    You can sort the table list by worksheet, the last update time, or table name.

TIP: In the list of active tables, you can click any table name to move the focus to the table in the worksheet.

Active table

An active table is a table being displayed on a worksheet. You can perform operations on a column in an active table. You can also perform operations on multiple active tables, for example, by joining them.

NOTE: The active table you are currently interacting with has a blue background for the table title. Other active tables in the worksheet have a gray background for the table title.

Hidden table

A hidden table is a table that you set aside to reduce clutter in your worksheet. You can also hide tables from a worksheet that you want to delete. For information about deleting a worksheet, see Deleting a worksheet. When you hide a table, both the table and the dataflow graph associated with the table disappear from the worksheet.

The hidden table can be added back to a worksheet in the future. If the worksheet from which the table originated exists, the table is added to that worksheet.

If you delete the worksheet after hiding the table, the hidden table is no longer associated with any worksheet. When you add it back to a worksheet, Xcalar Design displays the following modal window. Select the worksheet to which you want to add the table and then click CONFIRM.

Temporary table

Xcalar Design creates temporary tables in several ways.

A temporary table is a table that is no longer active after you perform an operation.

Example: Suppose you create from your dataset a table named airlines#pe8. It is the active table displayed in the worksheet, in which you can perform various operations. If you change the data type of one of its columns, a new active table named airlines#pe9 is created. The table named airlines#pe8 is now categorized as a temporary table.
NOTE: Remember to click in the Tables panel to refresh the temporary tables list after you run an operation or undo an operation. It ensures that the most up-to-date list is displayed.

How undoing an operation affects a table's status

A temporary table can be created when you undo an operation either through the Undo button or the Revert to this table option in a dataflow graph. Xcalar Design does not drop the table resulting from the operation being undone; instead, it categorizes the table as a temporary table.

A temporary table created with an undone operation cannot be added back to the worksheet. Also, if another operation is performed in the active table, the temporary table is automatically dropped.

Example: Suppose you change a data type for a column in airlines#pe8 and the resultant table is named airlines#pe9. If you undo the data type change, airlines#pe8 becomes the active table again, but airlines#pe9 is not dropped. Instead, airlines#pe9 is kept as a temporary table, which enables you to redo the operation. If you do not redo the operation but perform another operation (for example, filtering a value), airlines#pe9 is automatically dropped.
NOTE: The temporary tables created by reverting are kept until you drop them. For more information about undoing an operation, see Undoing, redoing, and repeating an operation.

Hiding a table

You can only hide an active table. You cannot hide a temporary table. Follow one of these steps to hide a table:

  • Right click the title bar for an active table to display a menu. Then select Hide Table.
  • Right click a table icon in the dataflow for the table. In the menu, select Hide Table.
  • In the Tables panel, click the Active tab. Select a table from the active table list and then click . The following screenshot illustrates how to hide tables in the Tables panel:

Changing a table to an active table

You can change a hidden or temporary table to an active table in one of two ways. If the worksheet from which the table originated has been deleted, the table is added to the active worksheet.

From the Tables panel

Follow these steps to change the status of a table to active:

  1. In the Tables panel, display either a list of hidden tables or temporary tables.
  2. Select the table that you want to change to an active table. You can select multiple tables from one list.

    TIP: The temporary table list might be long. To quickly locate the temporary table, type the complete or partial table name in the Filter Temporary Tables field to limit the list to only tables with a matching name.
  3. Click .

The following screenshot illustrates how to put a temporary table on the worksheet.

From the dataflow graph

Follow these steps to change the status of a table to active:

  1. Display the dataflow graph for the worksheet.
  2. Locate the table you want to add back to the worksheet.

    NOTE: You can only add a temporary table, not an active table, to a worksheet. Therefore, do not select the last table icon in a dataflow graph, which represents an active table. Also, it is possible for an active table in one dataflow graph to be shown in the middle of another. For example, if you have added a temporary table named airlines#pe8 to the worksheet, airlines#pe8 is now an active table even though its icon remains in the middle of another dataflow, causing airlines#pe8 to look like a temporary table.
  3. Click the table icon to display a menu. Click Add Table To Worksheet.

Go to top