Are you after what the SQL chaps call a LEFT OUTER JOIN?
On 6 October 2011 12:03, DUGALEIX Michaël <[email protected]> wrote: > - I wanted to have pairs of DETAIL/MASTER in the output (to use JOIN and > SPEC afterwards), so I used the PAIRWISE option of LOOKUP. > And the PAIRWISE option needs the ALLMASTER option, if I correctly read the > LOOKUP diagram. > So I used the ALLMASTER option, even if my reference doesn't have multiple > masters. > "| L: lookup ... DETAIL ALLMASTER PAIRWISE", > "| join", > "| spec ...", > "! > "outputFile, > Is there a better/cleaner way ? > > - When you have multiple masters, how do you unravel them after having > joined them with "join keylength" ? > For example, if I have this before the "join keylength" : > a1 > a2 > b3 > b4 > b5 > and that afterwards : > a12 > b345 > > - Considering your answers, I'll try and be more precise : > Is there an idiom to enrich a big file (which may have several lines with > the same "key") with another reference-file (which can't have more than one > line with a given key) ... > 1. ... if the reference file is not too big ? > 2. ... if the reference file is big ? > > - I looked at your stage, I saw my new friend "not fanout", and "gate" I'm > not familiar with, so I'll need time to digest that one ! > > Thanks > Michaël > >> http://rvdheij.wordpress.com/2011/10/05/binary-search-stage/ >> >> Sir Rob the Plumber >
