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
Last Modified Date: 14 Mar 2016
Environment
Tableau Desktop
Resolution
Do either of the following options:
- Create an extract of the data.
- 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials