I only want to lookup the modified version if the un-modified version is not found (but thanks for that idea Rob).
The faninany/copy was what I was looking for, thanks to both of you. -- bc On Wed, Aug 5, 2009 at 1:36 PM, Schuh, Richard<[email protected]> wrote: > 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 >> >> >>
