Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Mask the column dynamically in DDM
Solution
You can use the "\(col)" function instead of actual column name to use the column name dynamically​.

Example

If our requirement is to mask the data for the  column having sting "TAX_ID​" you can use the below function:
CASE WHEN (\ (col) IS NULL ) THEN NULL ELSE SUBSTRING(\ (col), 1, 1) ++ 'XXXXX' END 
More Information
Reference
Applies To
Product: Dynamic Data Masking
Problem Type: Configuration
User Type: Administrator
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:7/9/2019 1:21 AMID:572364
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)