Help Centre › Building Processes
Join two lists of records on a key, as a database join does.
Add it to a process
In the process designer, open the Add step tab. Find Join lists under Data, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| First list | Yes | The name of the first list variable, without braces. |
| Second list | Yes | The name of the second list variable, without braces. |
| Match on field | Yes | The field both lists are matched on, such as invoice number |
| Field in the second list | No | Only when the second list names the field differently. |
| Keep | No | "inner" keeps only records found in both lists; "left" also keeps first-list records with no match, with the second list's fields left empty. Defaults to inner. Choices: Only records in both lists, Every record in the first list. |
| Save the joined list in | Yes | Name of the variable to store the joined list in |
What it gives back
{variable}
See all Data steps.