Filed value after Full Outer Join ???
Posted: Thu Sep 23, 2004 6:30 am
Hello Everybody,
Is anaybody can help me:
I have Two Input Sequential Files:
File A with Field A1 as Key, FieldA2
File B with Field B1 as Key, FiledB2
I do a full Join on FileA.FieldA1 and FileB.FieldB1.
In transform, depending on the source, I would like to put the good key A1 or B1: If A1 exist then C1 = A1 else C1 = B1.
But which value can I test for A1? I try Null, Blanck?
I cannot found the format that Ascential put if I have no data.
Thanks for your help,
Pey
Is anaybody can help me:
I have Two Input Sequential Files:
File A with Field A1 as Key, FieldA2
File B with Field B1 as Key, FiledB2
I do a full Join on FileA.FieldA1 and FileB.FieldB1.
In transform, depending on the source, I would like to put the good key A1 or B1: If A1 exist then C1 = A1 else C1 = B1.
But which value can I test for A1? I try Null, Blanck?
I cannot found the format that Ascential put if I have no data.
Thanks for your help,
Pey