Skip to main content
Version: V3.8

Unused Field

The field "Field: xxx" was not used in any charts or master items. This field could likely be dropped from the data model with no loss of analysis. Dropping this field would recover nn bytes.

The field was not found to be referenced in any resource -- Chart, Variable, Bookmark, etc -- or used as a key field. Removing the field from the script would reduce memory requirements by the indicated number of bytes.

It may be convenient to first use a script DROP FIELDS statement to remove fields and then validate you application. The Drop Fields tab of the Script Generator dialog, opened from the Analysis Tools menu, will generate a filtered DROP FIELDS script statement for you.

There are some indirect "uses" of fields that QSDA can not detect such as:

  • Fieldnames as a string list, such as may be used to populate a set of dropdown choices to feed a variable. e.g. "Customer;Country;Product"

To keep such fields from being flagged, list them in the Collector option Field Names always in use. Matching fields are treated as used and are never flagged as unused. Enter one entry per line: an exact field name, a field name pattern with * wildcards such as Sales*, or table: followed by a table name to include all fields in that table. Matching ignores case.

After dropping fields, it is recommended to run a QSDA collection to see if any syntax errors or "missing" flags have surfaced.