Merge Extended

Merge data from multiple inputs with dynamic input count support

Merge Extended

AI-generated

Summary

Merge data from multiple inputs using various modes: append all items sequentially, combine based on matching fields, position, or all combinations, execute a custom SQL query on inputs, or select a single input branch to output.

Inputs

  • Mode (required) — Select how to merge the data: Append, Combine (with sub-options), SQL Query, or Choose Branch.
  • Number of Inputs (required) — Set how many inputs to merge (10 to 20 inputs supported).
  • Combine By — When mode is Combine, choose how to combine items: by Matching Fields, Position, or All Possible Combinations.
  • Fields to Match — Comma-separated field names used to match items when combining by matching fields.
  • Output Type — When combining by matching fields, specify which items to keep: matching items only, non-matching only, all items, or enrich Input 1 (left join).
  • Clash Handling — When combining, decide how to resolve field name clashes: prioritize Input 1, prioritize Input 2, or add input number suffix to field names.
  • SQL Query — Write a custom SQL query referencing inputs as tables (input1, input2, etc.) to merge data.
  • Choose Input — When mode is Choose Branch, select which single input to output.
  • Options — Additional options for combining, such as fuzzy compare, disabling dot notation in field names, or including all unpaired items on position combine.

Output shape

a list of items (JSON objects) representing the merged data

Output shape varies by mode: Append concatenates all input items, Combine merges items using matching fields, position, or all combos, SQL Query outputs query result rows, and Choose Branch outputs one selected input's items or an empty item. Number of inputs handled depends on 'Number of Inputs' parameter.

Examples

Example 1: Append mode with 10 inputs

Outputs all items from all inputs sequentially as a single merged list.

Example 2: Combine mode, matching fields on 'id' and 'email', with output type 'Keep Matches' and clash handling 'Prioritize Input 2'

Outputs merged items that match on specified fields, resolving conflicts by prioritizing fields from second input.

Example 3: SQL Query mode with custom query joining input1 and input2

Outputs the result set from the specified SQL query that references input data as tables.

Discussion