Delete Data

Deletion is irreversible

A tradeoff that Tabmega makes in order to handle big data is deletion is irreversible. There is no undo functionality to bring back data because storing the history of all the data takes up too much space. Be careful using deletion.

In this section we’ll show the steps for deletion, but we won’t perform the final click to confirm the deletion.

Delete columns

To delete a column, click on the icon in the top right of the column. Then select Delete. You will need to confirm the deletion as well because deletion is irreversible.

Delete Tables

To delete a table, click on the dropdown icon of the tab you want to delete. Then select Delete. You will need to confirm the deletion as well because deletion is irreversible.

Delete Rows

Tabmega takes a different approach to deleting rows compared to Excel and Google Sheets. To delete rows, you can filter only for the rows you want, and then create a copy of the filtered table values.

If you’ve been following the tutorial, let’s see how it works by walking through the steps to delete all rows in the comedy_viewership table where the percentOfUsers is between 4-5%.

1. As described in the filter by condition section, we’ll want to forst create a formula column that calculates if the percentOfUsers is between 4-5%.

2. Name the column is between 4-5%.

3. The formula we want is =and(.04<=comedy_viewership.percentOfUsers,comedy_viewership.percentOfUsers<=.05).

4. As usual, click Apply or Shift+Enter to calculate the new column.

5. Click on the icon in the top right of the is between 4-5% column and select Filter.

6. In this case we want to Exclude values and select TRUE values.

7. As usual, click Apply or Shift+Enter to filter the table. When it’s done we can see there are 15,970 rows of data with the filter.

8. Click on the dropdown icon in table tab, and select Copy values to new table.

9. In the menu that appears, ensure Only copy filtered rows is checked. Then click Copy To New Table.

10. We can see the new table has 15,970 rows of data. The rows with percentOfUsers between 4-5% have been deleted!