Hashes (encrypts) the selected columns and creates a new column for each including the hashed values. Three different hashing algorithms are available:
Algorithm | Description |
sha224 | Generates a 112-bit signature. |
sha256 | Generates a 256-bit signature. |
md5 | Generates a 128-bit signature. |
Example

Example Input
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
BBB | EEE | 222 |
CCC | FFF | 333 |
Example Output (hash abbreviated)
dim_A | dim_B | metric_1 | dim_A_hash |
AAA | DDD | 111 | 808751af5f7936... |
BBB | EEE | 222 | c79508d98c079... |
CCC | FFF | 333 | 26802ee238a56... |
I Ain't Afraid of No Code!
[
[
"hash",
{
"targetfield": "dim_A_hashed",
"subtable": null,
"algorithm": "sha224",
"sourcefields": [
"dim_A"
],
"_comment": null
}
]
]
param str targetfield: The translation engine to use, either Google or Bing.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str algorithm: Numeric corresponding to the source field language.
param int target_language: Numeric corresponding to the target field language.
param str field: Name of the source field that will be translated into the target language.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.