The 1010data Insights Platform provides a quick and easy way to perform a row selection within the current table or worksheet.

You can quickly perform a basic row selection directly from a table or worksheet by right-clicking any cell and then clicking a selection command in the menu.

To perform a row selection using the grid:

  1. In the grid view of an open table or worksheet, right-click the cell on which you want to base the row selection and point to Select rows.
    The 1010data Insights Platform displays a menu of selection commands.

  2. Click the desired selection command.
    Available selection commands are specific to the selected cell and include the following:
    Selection command Description
    Where <column_name> has the value <cell_value> Rows that have the same value in the same column as the cell you right-clicked will be selected.
    Where <column_name> does not have the value <cell_value> Rows that do not have the same value in the same column as the cell in which you right-clicked will be selected.
    Where <column_name> has greater value than <cell_value> Rows that have a greater value in the same column as the cell in which you right-clicked will be selected.
    Where <column_name> has smaller value than <cell_value> Rows that have a smaller value in the same column as the cell in which you right-clicked will be selected.
    Up to and including this one Rows listed before, and including, the row containing the cell you right-clicked will be selected.
    After this one Rows listed after the row containing the cell you right-clicked will be selected.
    The Insights Platform displays the results of your selection in the grid and adds the select operation to the Analysis Timeline.