Work with interactive tables

Basic table-related actions

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.

Select columns to display

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.

Set up filtering

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 respective 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.

Drop duplicate values

• Drop duplicated rows in the whole table:

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

  2. Select the Drop duplicated rows option from the menu.

     

• To drop duplicated rows in specific columns:

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

  2. Select the Drop duplicated rows in specified columns option from the menu. This will open the Drop duplicated rows in specified columns dialog.

  3. In the dialog, expand the list and select the columns you want to process.

  4. Click the Drop duplicates button.

     

• After the table is updated, you can generate code for the resulting output by clicking Export to code cell next to Process data.

Find and replace

1. Click the Find and replace icon in the lower right corner of the table cell. This will open the Find and replace interface under the table.

2. Use the search option:

   1. Under Find, enter your search string.

   2. To customize the search, click the gear icon and select if you want to make your search case-sensitive (Match cases) or search the entire table cell(Match entire table cell content). To close the find search settings, press Esc.

3. To select columns for searching, do the following:

   1. Under Search scope, expand the list of columns.

   2. Select the columns you want to search.

   3. Press Esc to collapse the list.

   As a result, you may have:

   • One match (cell with the matching string highlighted)

   • Several matches (highest cell with the matching string highlighted)

4. To view the cells with the matching string, click the up and down arrows next to the Replace button.

5. To replace the matching string with another string, do the following:

   1. Under Replace with, enter the new string.

   2. To replace the string in the currently highlighted table cell, click the Replace button. The string will be replaced accordingly, and the next cell with the matching search string becomes highlighted.

   3. To replace the string in all matching table cells, click the Replace all.

Manipulate individual columns

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.

   

Change table field values

1. Double-click the table cell with the value you want to change. The current value will be highlighted.

   

2. Enter the new value. Make sure you use a supported data type.

3. To save the new value, press Enter or click anywhere outside the selected cell.

The cell containing the new value will be marked with a blue dot.