KNOWLEDGE BASE

Error "Prep Collate error, unable to run flow" When using a Flow With Multiple Unions


Published: 25 Jun 2019
Last Modified Date: 20 Sep 2019

Issue

When using a flow with multiple unions and excel files, the following error might occur:

"Failure evaluating to database: ERROR: collation mismatch, use COLLATE statements to resolve Try running the flow again or review the log file for more details."

 

Environment

  • Tableau Prep 2019.2.2
  • Excel

Cause

This behavior is related to a known issue (ID: 938199) and it has been fixed in Tableau Prep 2019.3.1 and later versions. 
Did this article resolve the issue?