KNOWLEDGE BASE

System Error "Failure evaluating to database: Abstract query SELECT [field name] is not defined" When Connecting to an Excel File


Published: 13 Sep 2019
Last Modified Date: 30 Dec 2019

Issue

After running a flow in Tableau Prep, the following system error might occur if the name of a header (column of an Excel File) contains characters like "\r" (for return carriage) or "\n" (for line feed): 

"Failure evaluating to database: Abstract query SELECT [field name] is not defined"

Environment

  • Tableau Prep Builder 2019.2.3
  • Excel

Cause

This behavior (issue ID: 977309) has been fixed in a recent version of Tableau Prep. 
Did this article resolve the issue?