Merge Node

Combine data from multiple branches. combineBySql is not supported — use combineByFields instead.

Written By pvdyck

Last updated 17 minutes ago

Merge Node

The Merge node combines items from two or more input branches into a single output.

Modes

ModeDescription
AppendAdd all items from all branches into one list (no matching)
Combine by Matching FieldsJoin items across branches by a shared field value (like SQL JOIN)
Combine by PositionPair items by their index position in each branch
Combine All PossibleCross-join: every possible pairing from both inputs
Choose BranchOutput data from a specific branch without modification
SQL QueryUse SQL to merge data (not supported on indie.money)

Parameters (Combine by Matching Fields)

ParameterDescription
Fields to Match OnField name(s) to match between inputs (e.g., id, email)
Join ModeInner Join (only matched), Left Join (all from Input 1), Right Join (all from Input 2), Outer Join (all from both)
Output TypeCombined (merge fields), Input 1, or Input 2
Clash HandlingWhen both inputs have the same field name: Always Add Suffix, Prefer Input 1, or Prefer Input 2

Parameters (Combine by Position)

ParameterDescription
Include Unpaired ItemsKeep items that have no match at the same index in the other input

Parameters (Choose Branch)

ParameterDescription
Output TypeWhich branch to use as output

Limitations

  • Combine by SQL is not supported -- The SQL-based merge mode relies on alasql, which is incompatible with Cloudflare Workers. Use "Combine by Matching Fields" instead.

Tips

  • Use Append to simply concatenate results from parallel branches
  • Use Matching Fields for database-style joins between two API responses
  • When inputs have uneven item counts, Position mode pairs what it can and optionally includes leftovers

Related