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
Filed value after Full Outer Join ???
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What stage type are you using? Given that it's a full outer join, either A1 or B1 might be NULL. Joins are defined the same way as in SQL. If you fail to find a row, NULL is returned. So you need, in your example, to test whether A1 is null.
(Is this really PX? Your description suggests server.)
(Is this really PX? Your description suggests server.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you post a few rows from each file? Sometimes actually inspecting the data can give inspiration as to what the problem may be.
Is there any conversion (say from "" to NULL) specified in the Format properties as these files are being read?
Perhaps add an extra output link to the Transformer stage that writes a file containing the exact input to the Transformer stage, so you can inspect that. (Does active stage tracing work in PX? I've never tried it. If it does, you could use that rather than modify the job. Limit the run to just a few rows, so that the trace file remains small.)
Is there any conversion (say from "" to NULL) specified in the Format properties as these files are being read?
Perhaps add an extra output link to the Transformer stage that writes a file containing the exact input to the Transformer stage, so you can inspect that. (Does active stage tracing work in PX? I've never tried it. If it does, you could use that rather than modify the job. Limit the run to just a few rows, so that the trace file remains small.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.