Join nodes
Join nodes take two or more inputs and combine them. Join has three outputs: rows from the left with no match, the matches, and rows from the right with no match, so nothing is dropped unless you leave an output unwired.
Append every Source row's columns onto every Target row (a cross join).
Look up an input field against a mapping table to replace found text or append matched fields.
Find records that mean the same thing despite typos, spelling, or word order. Cluster duplicates, or match against a reference list.
Combine two inputs on matching keys, returning the matched rows plus the unmatched orphans from both sides.
Combine 2 or more inputs into one on a shared key (or record position). Every row is kept by default, null-filled where they don't match.
Stack the rows of 2 or more inputs into one, matched by field name (or record position), with the fields reconciled.