Issue
When using a REGEXP_EXTRACT function on a Microsoft SQL Server data source, the following error might occur:"Unknown Function"
Last Modified Date: 04 Jan 2018
"Unknown Function"
Environment
- Tableau Desktop 10.4
- Windows 7
- MS SQL Server
Resolution
Option 1
Add your vote to this idea for Microsoft SQL Server: Regex functionality in pattern matching.Option 2
As a workaround, try leveraging RawSQL to pass-in functions that the data source supports (note that this will depend on what you wish to accomplish with the substring from the REGEXP function): Pass-Through Functions (RAWSQL).Cause
Support for regular expressions is not currently built into Microsoft SQL Server.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