Custom

Extract data from the input using a DIY or bespoke extraction wrangle. Requires WrangleWorks Account and Subscription.

Extract data from the input using a DIY or bespoke extraction wrangle. Can be performed on one column or multiple columns. Requires WrangleWorks Account and Subscription.

info

Non-regex pattern matching extracts whole-word matches separated by word boundaries. Word boundaries include anything that is not a letter, number, or underscore.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
`input`	Name or list of input columns.	string, integer, array	—	Yes
`output`	Name or list of output columns.	string, array, null	`null`	No
Options
`case_sensitive`	Allows the wrangle to be case sensitive if set to True, default is False.	boolean	`false`	No
`extract_raw`	Extract the raw data from the wrangle.	boolean	`false`	No
`use_spellcheck`	Use spellcheck to also find minor mispellings compared to the reference data.	boolean	`false`	No
`sort`	Sort the results.	string; one of: training_order input_order longest shortest alphabetical reverse_alphabetical ascending descending	`"training_order"`	No
Formatting
`use_labels`	Use Labels in the extract output {label: value}.	boolean	`false`	No
`first_element`	Get the first element from results.	boolean	`false`	No
`include_empty_labels`	Include labels with no found values in the output when using use_labels=True.	boolean	`true`	No
`output_format`	Format of the extract output.	string, null; one of: list dictionary columns concatenate	`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
Details
`model_id`	The ID of the wrangle to use.	string, array	—	Yes

Examples

# One column input
wrangles:
  - extract.custom:
      input: Product
      output: Wood Types
      model_id: model_id_here

Product
Dining Oakwood Chair
Living Room Teakwood Frame Mirror

Wood Types
Oakwood
Teakwood

# Multi column input
wrangles:
  - extract.custom:
      input:
        - Part 1 of 2
        - Part 2 of 2
      output: Wood Types
      model_id: model_id_here

Part 1 of 2	Part 2 of 2
Dining Acacia Wood Table	Imitation Wood Table Chairs

Wood Types
['Acacia Wood', 'Imitation Wood']

# Multiple Models
wrangles:
  - extract.custom:
      input:
        - Product
        - Product
      output:
        - Wood Types
        - Item Type
      model_id:
        - wood_Type_model_id
        - item_type_model_id

No sample available.

Product	Item Type	Wood Types
Dining Oakwood Chair	Chair	Oakwood
Living Room Teakwood Frame Mirror	Mirror	Teakwood

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	Yes
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	`25`
Catalog key	`extract.custom`
Recipe key	`extract.custom`
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	`extract`
Documentation group	`extract`
Aliases	None
Runtime symbol	`wrangles.recipe_wrangles.extract.custom`
Legacy UUID	`e8e96b76-86bf-41dc-8d16-825dcff9688b`

Sources

Parameters​

Examples​

Parameters

Examples