Bi-Merge (String)
Description
Similar to block Merge
, but also transports the strings in the second column of B
to both outputs (A1
and A2
).
Finds all items in A
for which the second column matches an object from B
.
Usually used to merge back objects which have previously been split.
Input
PAIRS [OBJ,OBJ]
: a list of pairs to be matchedA [OBJ,STRING]
: a list of pairs to be matched againstPAIRS
's first columnB [OBJ,STRING]
: a list of pairs to be matched againstPAIRS
's second column
Output
A2B2 [STRING,STRING]
: All the columns not involved in the match
Output scores can be aggregated and/or normalized.