Last Modified Date: 19 Mar 2022
Environment
- Tableau Prep Builder 2021.4.3
- MS SQL Server
Resolution
As a workaround, wrap the HASHBYTES function within a CONVERT() function, converting it to NVARCHAR(32).For example:
SELECT CONVERT(NVCHAR(32), HASHBYTES('MD5' , Column_Name),2) AS Column_Name;
Cause
This issue, ID 1372178, is currently under investigation.Additional Information
Using CONVERT with binary and character dataThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials