Merge¶
Node: merge · Full type: n8n-nodes-base.merge · Version: 3.2
Ergonomic keyword available:
MERGE— see NFLOW.md for shorter syntax.
Parameters¶
| Parameter | Type | Default | Details |
|---|---|---|---|
mode |
options | "append" | append, combine, combineBySql, chooseBranch |
combineBy |
options | "combineByFields" | combineByFields, combineByPosition, combineAll |
numberInputs |
options | 2 | 2, 3, 4, 5, 6, 7, 8, 9, ... (9 total) |
options |
collection | {} | keys: clashHandling, fuzzyCompare |
advanced |
boolean | false | |
fieldsToMatchString |
string | "" | |
mergeByFields |
fixedCollection | {...} | groups: values |
joinMode |
options | "keepMatches" | keepMatches, keepNonMatches, keepEverything, enrichInput1, enrichInput2 |
outputDataFrom |
options | "both" | both, input1, input2 |
query |
string | "SELECT * FROM input1 LEFT JOIN input2..." | required |
chooseBranchMode |
options | "waitForAll" | waitForAll |
output |
options | "specifiedInput" | specifiedInput, empty |
useDataOfInput |
options | 1 |
options children:
| Parameter | Type | Default | Details |
|---|---|---|---|
clashHandling |
fixedCollection | {...} | groups: values |
fuzzyCompare |
boolean | false |
mergeByFields children:
values group:
| Parameter | Type | Default | Details |
|---|---|---|---|
field1 |
string | "" | |
field2 |
string | "" |