KNOWLEDGE BASE

Error "unterminated identifier" When Creating Extract


Published: 27 Jun 2013
Last Modified Date: 20 Apr 2016

Issue

When you try to create an extract of Excel data, the following error might occur:

Tableau Data Engine Error: 4: unterminated identifier
Unable to create extract

Environment

  • Tableau Desktop
  • Microsoft Excel

Resolution

Check the worksheet that is producing the error to make sure there are no empty cells in the title row.

Cause

The Excel data source contains empty cells in the first (title) row of data.
Did this article resolve the issue?