Lists

Take lists in multiple columns and merge them to a single list.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
`input`	List of input columns.	array	—	Yes
`output`	Name of the output column.	string	—	Yes
Options
`remove_duplicates`	Whether to remove duplicates from the created list.	boolean	`false`	No
`ignore_case`	Ignore case when removing duplicates.	boolean	`false`	No
`include_empty`	Whether to include empty values in the created list.	boolean	`true`	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

wrangles:
  - merge.lists:
      input:
        - col1
        - col2
      output: Combined Col
      remove_duplicates: false

Col1	Col2
['A', 'B']	['D', 'E']

Combined Col
['A', 'B', 'D', 'E']

Access

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

Technical details

Field	Value
Catalog ID	`44`
Catalog key	`merge.lists`
Recipe key	`merge.lists`
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	`merge`
Documentation group	`merge`
Aliases	None
Runtime symbol	`wrangles.recipe_wrangles.merge.lists`
Legacy UUID	`d9978f00-b3d4-4583-884e-a53b98a43e9a`

Sources