Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Hide sensitive information that is provided in a separate mask table with keyword and replacing values. The operator replaces all keywords that are provided in the maskTable table. This operator works only on string types.
...
inputTable
: Table with the input data.maskTable
: Table that contains keywords (or sensitive strings) and values (random strings) to replace keywords.keywordColumn
: Column that contains the keywords.replaceColumn
: Column that contains the values to replace keywords.
Example
Input
inputTable
\
user | path |
---|---|
emil | /Users/emil/backend/testing |
test | /Users/Downloads/backend/kumar |
maskTable
user | mapping |
---|---|
emil | user123 |
kumar | user45 |
LQL command
Code Block |
---|
maskData(inputTable, maskTable, "user", "mapping") |
Output
\
user | path |
---|---|
user123 | /Users/user123/backend/testing |
test | /Users/Downloads/backend/user45 |