Match by Object
Description
Finds matches between the objects in second columns from the inputs. The result provides both the matching items, and the items from both inputs that didn't generate a match.
Input
A [OBJ,OBJ]
: a list of candidates, in which the second column will be used for comparison and the first column will be the resultB [OBJ,OBJ]
: a list of candidates, in which the second column will be used for comparison and the second column will be the result
Output
RESULT [OBJ,OBJ]
: the matched objects fromA
andB
NOTA [OBJ]
: the objects from A that did not match with an item fromB
NOTB [OBJ]
: the objects from B that did not match with an item fromA
Parameters
Exclude self-matches
: whether to emit the match if the objects inA
andB
are the same. Mostly useful whenA
andB
come from the same source