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: 09 Jan 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

As a workaround, instead of duplicating the field and then converting the duplicate to string, create a STR([Original]) calculated field in one step.

Cause

This behavior is related to a known issue with ID 856863 which is currently under investigation. 
Did this article resolve the issue?