Match by Date (Blocking)

Description

Finds matches between the DATE-columns in the inputs.

Input

  • A [OBJ,DATE]: a list of candidates, in which the DATE-column will be used for comparison and the OBJ-column will be the result
  • B [OBJ,DATE]: a list of candidates, in which the DATE-column will be used for comparison and the OBJ-column will be the result
  • Candidates [OBJ,OBJ]: candidate pairs, only As and Bs that are in Candidates will be matched

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

  • Comparison: Comparison function to use (=,!=,<,>,<=,>=,day-distance)
  • Max day-distance: when Comparison is set to day-distance, the match is valid only if the difference in days between the two dates is not greater than this value
  • 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