maskData

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.

Operator Usage in Easy Mode

1. Click + on the parent node.
2. Enter the Mask Data operator in the search field and select the operator from the Results to open the operator form.
3. In the Table drop-down, enter or select the table containing the data to run this operator on.
4. In the Column to Header Mapping, enter the columns to be included in the output.
5. Click Run to view the result.
6. Click Save to add the operator to the playbook.
7. Click Cancel to discard the operator form.

Usage Details

LQL Command

maskData(inputTable, maskTable, keywordColumn, replaceColumn)

Input

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

maskTable

LQL command

maskData(inputTable, maskTable, "user", "mapping")

Output