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 result
  • B [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 from A and B
  • NOTA [OBJ]: the objects from A that did not match with an item from B
  • NOTB [OBJ]: the objects from B that did not match with an item from A

Parameters

  • Exclude self-matches: whether to emit the match if the objects in A and B are the same. Mostly useful when A and B come from the same source