KNOWLEDGE BASE

"ERROR collation mismatch, use COLLATE statements to resolve" On Output When Duplicate Number Field Converted to String


Published: 08 Jan 2019
Last Modified Date: 19 Feb 2019

Issue

When you duplicate a number field, then convert to string and use a group and replace, an output step returns the following error:
ERROR collation mismatch, use COLLATE statements to resolve

Environment

Tableau Prep 2018.3 

Resolution

Option 1: 

Upgrade to Tableau Prep 2019.1.1 or a newer version. Click here for downloads of Tableau Prep: Tableau Prep Downloads and Release Notes. For more information on current releases, see Install Tableau Prep and Prep Upgrade.

Option 2: 

Use one of the following workarounds.

  • Instead of duplicating the field and then converting the duplicate to string, create a STR([Original]) calculated field in one step.
  • Convert the flat file to a .hyper and use the .hyper in the flow instead.

 

Cause

This behavior is related to a known issue with ID 856863 which has been corrected in Tableau Prep 2019.1.1.
Did this article resolve the issue?