Select rows panel

The Select rows panel allows you to specify the selection criteria using the simple comparisons options or enter a selection expression in the Expression Editor.

The Select rows panel is accessible from the following locations in the 1010data Insights Platform:
  • Analysis Timeline in the Trillion-Row Spreadsheet
  • Right-click menu in the grid

It is important to note that the Select rows panel available in the grid is visually different from the panel in the Analysis Timeline. While the panels vary slightly from one another, the available fields and functionality is identical. For illustration purposes, this topic shows images of the Select rows panel as it appears in the timeline.

Figure: Select rows panel in the Analysis Timeline
A. Simple Comparisons
In a new Select rows panel, the Simple Comparisons option is selected by default. When selected, fields and options used to specify the criteria for a row selection are displayed in the Simple Comparisons view. Clear this option to display the Expression Editor view.
B. Case-insensitive
When the selected column is a text column, select this option to ignore case in your search. This option does not appear for non-text columns.
C. Look up column values
If you select this option, you can start entering a value, and the Select Row panel will display relevant values in a drop-down list. You can then select a value from the drop-down list.
D. Display as QuickFilter
If you select this option, the search criteria will appear in the results pane along with the resulting table.
E. Column
This drop-down list contains the columns in the table or worksheet. By default, the first column in the table or worksheet is displayed first in the list. When the list is open, you can filter the list of columns by entering text in the search field. This is helpful if your table or worksheet contains a large number of columns.
F. Relationship
This drop-down list contains the options used to specify the relationship (e.g., equal to, greater than, contains, etc.) between a column and a value. For a list of relationship options, see Simple comparisons relationship options.
G. Value
This field is used to enter or select the value for which you want to search in the table or worksheet.

The combination of the column, relationship, and value are called a term and define the criteria required for a row selection. As an example, if you wanted to select all rows in a table where the word "milk" appears in a cell within a specific column, you would select the desired column from the Column drop-down list, select contains from the Relationship drop-down list, and enter milk in the Value field.

H. Add Value
This icon adds an additional Value field to the selection criteria.

Adding additional Value fields creates an or selection. This type of selection includes only those rows that meet any of the entered value criteria.

To remove a Value field from the selection criteria, click the Remove Value () icon.

I. Add 'or' Term
This button adds an additional set of selection criteria, called a term, to the row selection. A term is the combination of the column, relationship, and value.

Adding an additional term creates an or selection. This type of selection includes rows that meet any of the of the entered value criteria.

J. Add 'and' Term
This button creates an and selection. This type of selection includes rows that meet all of the entered value criteria.
K. Negate
Click this button to negate the relationship selected in the Relationship drop-down list. For example, a relationship of "has the value" (=) will become "does not have the value" (≠), and a relationship of "contains" will become "does not contain".
L. Expression Editor
The Expression Editor is available from the Expression Editor view in the Select rows panel. To access the Expression Editor, clear the Simple Comparisons option. For an easy shortcut, simply type "=" to view the Expression Editor. For more information about the Expression Editor, see Expression Editor.

The Expression Editor allows you to enter a selection expression to perform a row selection. For instructions, see Select rows by entering a selection expression.