Hash
Create a hash of a column.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name of input column. | string, integer, array | — | Yes |
output | Name of new column. | string, array | — | Yes |
| Options | ||||
method | The method to use to hash the input (Default: md5). | string; one of:
| "md5" | No |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- create.hash:
input: Description
output: hash
method: md5
| Description |
|---|
| The wrench is blue |
| The hammer is yellow |
| New Column |
|---|
| ce114e4501d2f4e2dcea3e17b546f339 |
| a54d88e06612d820bc3be72877c74f257b561b19 |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 16 |
| Catalog key | create.hash |
| Recipe key | create.hash |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | create |
| Documentation group | create |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.create.hash |
| Legacy UUID | 11e8fc13-00d2-4779-8d87-6288b07de7e7 |
Sources