Interactive table output

1. Use horizontal and vertical scrolling to view entire table output when necessary.

2. Click Jump to top or Jump to bottom to quickly navigate to the upper or lower rows of the table.

3. To download table content as a .csv file, click the Download .csv icon in the lower right corner of the table cell.

4. To copy the content of the table rows, click the Copy up to 10000 row to clipboard icon in the lower right corner of the table cell.

   note

   If the number of rows exceeds 10000, the first 10000 rows will be copied.

By default, the table output includes all columns. You can select which columns to exclude.

1. Click the icon next to the n columns x n rows in the lower left corner of the table cell.

2. In the opened dialog, expand the list to deselect the columns that you want to hide.

3. Deselect the Show index column to exclude the index column from the table.

4. Click Apply to confirm the changes to the table.

Apply filtering to table columns by adding filtering conditions.

1. Click the filter icon in the lower right corner of the table cell.

2. In the Filter dialog, expand the column list to select the column that you want to filter.

3. Set up the filtering condition for the selected column:

   • To filter the column by records containing a specific string, make sure Contains (default option) is selected and enter the filtering string in the text field.

   • To filter the column by the records equalling a specific value, click Contains:, select Equals from the list, and enter the value in the text field.

4. (Optional) To add a condition to the filter, click Add condition and repeat the procedure.

5. (Optional) To apply filtering to another column, click the Add filter button and repeat the procedure.

6. To delete a filtering condition, click the Trash icon for the resoective condition.

7. To delete all filters, click the Remove all filters button in the lower right corner of the dialog.

8. To confirm the filtering settings and conclude the procedure, click the Apply button in the lower left corner of the dialog.

tip

Another way to open the Filter dialog is to click the arrow icon next to the header of a column in the table and select Filter from the list.

1. Copy a column title by clicking the column header. You will get a notification.

2. Resize columns: hover over either side of the column and drag them.

3. Rename a column:

   • Click the arrow icon in the header of the column that you want to rename. This opens the column context menu.

   • Select Rename column from the context menu. This focuses the column header.

   • Type the new column header and press Enter.

4. Apply sorting:

   • Click the arrow icon next to the header of the column that you want to sort. This opens the column context menu.

   • Select Sort ascending or Sort descending from the context menu.

     note

     If a column contains string type data, it is sorted alphabetically.