Faninany in the primary input - you will need a stage to consume the record 
prior to sending it to the faninany. Copy or elastic should do the job. 

    ... | f: faninany |l: lookup ... \ l: | ... Modify the record | copy | f:

Regards, 
Richard Schuh 

 

> -----Original Message-----
> From: CMSTSO Pipelines Discussion List 
> [mailto:[email protected]] On Behalf Of Bob Cronin
> Sent: Wednesday, August 05, 2009 10:27 AM
> To: [email protected]
> Subject: Re: Re-lookup?
> 
> But I don't want it in the reference, I want it in the 
> details. The reference contains a table of known-valid Notes 
> email addresses and their rfc822 equivalent and the details 
> contains a table of Notes addresses I am trying to determine 
> the rfc822 equivalent for. If I don't find a candidate 
> address in the reference, I want to see if it has a "/Contr/" 
> in it, remove it if so and re-look-it-up in the known-valid table.
> 
> What am I missing here?
> --
> bc
> 
> On Wed, Aug 5, 2009 at 1:23 PM, Schuh, Richard<[email protected]> wrote:
> > Feed them in to the tertiary input stream.
> >
> >
> >  Tertiary Input Stream:  When a record is read on the 
> tertiary  input  
> > stream,
> >  the  contents  of  the second input range are used as the 
> key.  The 
> > record is
> >  added to the reference if there is not already a record in the 
> > reference  for
> >  the key.  The record is also added if ALLMASTERS is specified.  
> > Otherwise the
> >  record is a duplicate and it is passed to the quinary 
> output stream 
> > (if it is
> >  defined and connected).
> >
> > Regards,
> > Richard Schuh
> >
> >
> >
> >> -----Original Message-----
> >> From: CMSTSO Pipelines Discussion List 
> >> [mailto:[email protected]] On Behalf Of Bob Cronin
> >> Sent: Wednesday, August 05, 2009 10:19 AM
> >> To: [email protected]
> >> Subject: Re-lookup?
> >>
> >> Is there a way to take detail records that were not found in the 
> >> reference, modify them and then feed them back into the 
> same lookup?
> >>
> >> For example let's say I am looking up an email address 
> >> "Bob_Cronin/Contr/Poughkeepsie/IBM" and don't find it in the 
> >> reference, can I on-the-fly-without-having-to-code-another-lookup 
> >> take that non-matching record, modify it to 
> >> "Bob_Cronin/Poughkeepsie/IBM"
> >> and look it up again?
> >>
> >> There seem to be lots of documented options for adding 
> records to the 
> >> reference on the fly, but not to the details.
> >>
> >> Am I just being silly here?
> >> --
> >> bc
> >>
> 

Reply via email to