Hi all, I'm removing duplicates, and sorting both my input fields one of which is Nullable.
eg; colA(NotNull) colB ( Nullable)
10 N
10 Y
10 Null
when I sort on both col A and B and say keep nulls last for col B, and remove duplicates based on A, the output is 10 N and 10 Null when I should be getting only 1 record 10 N. Does the sort or remove duplicate stage doesnt work well with Nullable fields ?? I'm on PX7.1
Thanks
Remove Duplicate Stage
Moderators: chulett, rschirm, roy
We use Remove Duplicate stage to eliminate duplicates and what we have done was to transform the null value and submit the result set to RD stage and that would eliminate duplicates in the mentioned key column. So i would suggest you to handle null before submitting the results to RD stage.
HTWH.
Regards
Saravanan
HTWH.
Regards
Saravanan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for posting your "solution". Sometimes questions like those are valuable in "taking a step backwards" from your design. Another good thing is to have someone else look at it - it's amazing how the problem you couldn't see is blindingly obvious to them! And if they're professional they won't seek to embarrass you with it.
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.