Table search and filtering in a Decision Optimization experiment
You can filter tables in the Prepare data, Explore solution and Visualization views, by clicking the search icon and entering a value to search on.
You can also specify a column name, colon, and a value. For example, if you
enter food:hot in the diet_food_nutrients table search
field, the table is filtered to display only the rows that contain the food "hot". In this example,
you obtain just one row that contains the food Hotdog
. You can also enter the
prefix of a column name. For example, entering fo:hot
obtains the same result as
food:hot
. The column name is optional, so you can also enter
hot in this case. If the column name is not specified, all columns are
searched and the corresponding rows are obtained. For example, if you enter
0, in the diet_food_nutrients
table you obtain four rows
that contain this value in one of the columns. You can also filter by using numeric values as
follows:
Enter in the search field | Result: rows displayed containing column values |
---|---|
column_name:12 | Equal to 12 |
column_name :10.. | Greater than or equal to 10 |
column_name :..10 | Less than or equal to 10 |
column_name:15..25 | Between 15 and 25 |
You can reorder the rows in the table by clicking the sort arrows on a table column. You can also select more than one column to sort by.
You can also compare tables of different scenarios. Click the three dots next to the table, and select Compare with to choose a scenario. For more information, see Comparing scenario tables in a Decision Optimization experiment.