KNOWLEDGE BASE

Error “Unknown function REPLACE called”


Published: 27 Jun 2013
Last Modified Date: 14 Mar 2016

Issue

When you create a calculated field using the REPLACE function, the following error appears in the Calculated Field dialog box.

Unknown function REPLACE called

Environment

Tableau Desktop

Resolution

Do either of the following options:

  1. Create an extract of the data.
  2. Duplicate the data in a data source that supports the REPLACE function

Cause

The REPLACE function is not supported by the following data engines:
  • Microsoft Jet (Text file, Excel, and Access)
  • Netezza
  • Teradata

Additional Information

The behavior of REPLACE is similar to COUNTD. See the related links for more information.

Did this article resolve the issue?