Issue
When using a REGEXP_EXTRACT function on a Microsoft SQL Server data source, the following error might occur:"Unknown Function"
Last Modified Date: 26 Nov 2019
"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.Additional Information
Discuss this article... Feedback Forum
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