KNOWLEDGE BASE

Error "Failure evaluating to database: ERROR: collation mismatch, use COLLATE statements to resolve" When Running Output Step in Prep


Published: 14 Aug 2019
Last Modified Date: 20 Sep 2019

Issue

When running Output step in Tableau Prep, the following error occurs:

"Failure evaluating to database: ERROR: collation mismatch, use COLLATE statements to resolve"

Environment

  • Tableau Prep 2019.2.3
  • Excel

Cause

When two data sources are joined together and they don't have the same collation, the output step will fail. This behavior was related to a known issue (ID: 951015) and it has been fixed in Tableau Prep 2019.3.1 and later versions. 
Did this article resolve the issue?