Cell options

This section describes the cell options that enable you to manipulate a table based on a value in a particular cell. The exact cell options available depend on the data type of the table column.

To display the cell options, click a table cell.

Filter this value

This option creates a table based on the selected values in a table column. The resultant table contains only rows with the selected values in the column. This option is not available for an array column.

Exclude this value

This option creates a table based on the selected values in a table column. The resultant table contains all rows except the ones with the selected values in the column. This option is not available for an array column.

Copy to clipboard

You can copy the value in the selected cell to the clipboard so that you can paste the text in another location either in Xcalar Design or another application.

Examine

This option is available only for Array and Object columns. It displays a portion of the Data Browser pertaining to the array in the selected cell. You can view the value for each element in the array, or add an element as a column. For more information about using the Data Browser, see Adding columns from a dataset to a table.

The following screenshots illustrate the Examine option and the Data Browser it displays.

Pull all

This option is available only for Array and Object columns. It pulls all elements of the array or object to create a column for each element. The following screenshot shows an example of three columns created from the items in an array (leftmost column) through the Pull all option.

Go to top