How to Automatically Delete Broken Tables

Tables can become broken for a variety of reasons. Sometimes, instead of fixing the error mentioned for each table, you may want to just delete all of the broken tables automatically, which is 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 be showing a red outline with an error message, and will have a specific error message in red above the object inspector. 

In this example, a combo box dropdown that was 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

Please note these steps require a Displayr license.

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

Method

1. From the toolbar, select Tools > Delete > Delete If Broken.

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

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 back to a table by selecting Table.

Then use the Delete If Broken automation to remove the broken output.

Next

How To Automatically Delete Tables With Low Sample Sizes

How To Automatically Delete Tables With No Significant Results