| 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 |