transformations:anonymizehash
Table of Contents
ANONYMIZE/HASH
Category: Transform / Advanced
Description
This action deterministically calculates hashes for values in one or multiple columns.
Use Cases
Using this action, you can anonymize data without affecting its cardinality so it can be used for merging and aggregation.
Action settings
| Setting | Description |
|---|---|
| New column name | Enter a name for the new column containing the hashes. |
| Position | Select where the new column will be positioned in the dataset. Options: Rightmost, Leftmost, or After column (and select an existing column). |
| Salt | Check this option and enter a salt value to be used within the creation of the hashes. |
| Anonymize also empty values | Check this option to generate hashes for empty values. |
| Columns | Select the columns from the list to be anonymized/hashed. |
Examples
Example #1
Create hash values for the following records of personal information.
Before (source table)
| FirstInit | LastName |
|---|---|
| G | Smith |
| M | Torres |
| R | Burke |
After (result table)
| FirstInit | LastName | Hash |
|---|---|---|
| G | Smith | MbUVm13bfrvQO7uiTs+XzQ |
| M | Torres | 3lO2kZjJItmnE2EqgtE0LA |
| R | Burke | zQhY9YonjxxYdlHeSZtFhg |
Action parameters
New column name: Hash
Position: Rightmost
Columns: FirstInit, LastName
transformations/anonymizehash.txt · Last modified: 2025/01/19 23:43 by craigt