KNOWLEDGE BASE

Error "Ignoring calculated field, field is already defined by data source" Opening Workbook


Published: 04 Apr 2013
Last Modified Date: 13 Feb 2017

Issue

When opening a workbook that uses an extract, an error similar to the following might occur:

Ignoring calculated field '{Field name 1}', field is already defined by data source.
Ignoring calculated field '{Field name 2}', field is already defined by data source.
Ignoring calculated field '{Field name 3}', field is already defined by data source.

 

Environment

Tableau Desktop

Resolution

Option 1

If you have not saved the workbook after receiving the error message, complete the following steps:

  1. Close the workbook without saving it.
  2. Delete the Tableau data extract (.tde) file.
  3. Open the workbook.
  4. When prompted, regenerate the extract.

If you have saved the Tableau workbook after initially receiving the error message, complete these steps instead.

  1. Delete the Tableau data extract (.tde) file.
  2. (If applicable) Delete and recreate any corrupted fields or groups in your Excel workbook.
  3. Recreate the extract from the live connection.

Option 2

To share a data source, publish it to Tableau Server as a Tableau Server data source. For more information, see Publishing Data Sources.
 

Cause

The workbook was saved immediately after creating new calculated fields. Then the extract was refreshed, but the workbook was not saved again.
This issue can also occur if a Tableau data extract (.tde) file is shared locally. 

 

Additional Information

To avoid the issue in the future, always save the workbook after refreshing an extract.
Did this article resolve the issue?