Properties
Extract text properties from the input. Requires WrangleWorks Account.
Extract categorical properties from unstructured text, such as colours or materials. Requires WrangleWorks Account.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name of the input column. | string, integer, array | — | Yes |
output | Name of the output columns. | string, array | — | Yes |
| Options | ||||
property_type | The specific type of properties to extract. | string, null; one of:
| null | No |
| Formatting | ||||
return_data_type | Legacy format option. Prefer output_format. | string; one of:
| "list" | No |
first_element | Get the first element from results. | boolean | false | No |
output_format | Format of the extract output. | string, null; one of:
| null | No |
char | Character to use when output_format is concatenate. | string | ", " | 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:
- extract.properties:
input: water bottles
output: properties
No sample available.
| Products | Product Properties |
|---|---|
| Stainless Steel Blue Bottle | {'Colours': ['Blue'], 'Materials': ['Stainless Steel']} |
| Plastic Yellow Bottle | {'Colours': ['Yellow'], 'Materials': ['Plastic']} |
wrangles:
- extract.properties:
input: water bottles
output: properties
property_type: colours # Optional
No sample available.
| Products | Product Colours |
|---|---|
| Stainless Steel Blue Bottle | ['Blue'] |
| Plastic Yellow Bottle | ['Yellow'] |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | Yes |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 29 |
| Catalog key | extract.properties |
| Recipe key | extract.properties |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | extract |
| Documentation group | extract |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.extract.properties |
| Legacy UUID | 23bbdb86-fd13-4b78-8fff-a7a76769ab63 |
Sources