How can I set a default vale when a lookup fails?
Posted: Fri Sep 19, 2008 4:29 am
Hello all.
How can I set a default vale to a field when there is a lookup failure?
I using a Lookup Stage to find matches between master and reference data. The goal I to append a field to the master data file with data from a field from the reference data were there matches. When there is no match I need to append a "0".
How can this be done using a Lookup Stage? I have all but append code in place.
Thanks in advance for your help.
How can I set a default vale to a field when there is a lookup failure?
I using a Lookup Stage to find matches between master and reference data. The goal I to append a field to the master data file with data from a field from the reference data were there matches. When there is no match I need to append a "0".
How can this be done using a Lookup Stage? I have all but append code in place.
Thanks in advance for your help.