How to Automatically Delete Broken Tables

Tables can become broken for a variety of reasons. Sometimes, instead of fixing the errors mentioned for each table, you may want to automatically delete all broken tables, as described in this article. Broken tables can be identified in the Report tree by a red! mark in a circle. The item in error will show a red outline and a specific error message in red above the object inspector.

In this example, a combo box dropdown used to filter tables was deleted, causing the filter and, subsequently, the tables to be in error.

and:

Once the function has been run, all broken tables will be removed from the document.

Requirements

One or more broken built-in drag and drop tables in the document that you want to delete.

Method

1. From the Report tree, right-click the page and select Delete > Delete If Broken.

2. You will get a dialog showing what tables have been deleted, like this:

confirm delete table.png

NOTE: This will delete only tables that were created using drag and drop, not other objects like visualizations. If your visualization has been transformed directly from a table (i.e., selecting the table and creating the visualization from the Visualization dropdown in the object inspector You can revert to a table by selecting Table.