On Wed, Aug 5, 2009 at 7:18 PM, Bob Cronin<[email protected]> wrote: > 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?
Sure, you probably want "fanintwo" with that, and maybe a "copy" stage. > 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? Have you considered the option to produce both detail records upfront and pass both of them through the lookup? In many cases that works when only one of them will produce a hit anyway. I have done things like that to implement limited wildcards, simply generate all detail records and feed them through lookup. Or maybe divert part of the detail to another lookup and match them there. > 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? Yes, I think so. But more silly than the rest of us?
