Description
The Decrypt Columns activity is used to convert encrypted column values back to their original readable form using a user-provided password. This is useful when sensitive information (e.g., names, emails, IDs) has been encrypted for security and now needs to be decrypted for analysis or reporting.
It supports decryption of multiple columns using symmetric two-way encryption, meaning the same password used to encrypt the data must be used to decrypt it.
Use case: Decrypt personal identifiable information (PII) like names and contact numbers that were encrypted for compliance purposes.
| Input Type | Required |
|---|
| Data | Required |
Output
| Output Type | Format | Description |
|---|
| Data | Tabular | Data with specified columns decrypted |
Configuration Fields
| Field Name | Required | Description |
|---|
| Column names | Yes | One or more columns to be decrypted. These must contain encrypted strings. |
| Password | Yes | The password or key used for decryption. Must be the same as used in encryption. |
| ID | Name |
|---|
| 1 | U2FsdGVkX1+abcdef123= |
| 2 | U2FsdGVkX1+ghijk456= |
Sample Configuration
| Field | Value |
|---|
| Column names | [“Name”] |
| Password | mySecretKey |
Sample Output
