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
A [OBJ,OBJ]
: a list of pairs to be searchedB [OBJ,STRING]
: a list of pairs to be merged withA
Output
A1B2 [OBJ,STRING]
: from the first column ofA
only those items of which the second column matched withB
, and the matching string from the second column ofB
A2B2 [OBJ,STRING]
: items from the second column ofA
that matched withB
and the matching string from the second column ofB
Output scores can be aggregated and/or normalized.