Hi,
I have few SORT columns defined as NULLABLE and in certain cases, for some records, these SORT columns are set to NULL [just to ensure, these are sorted way down]. Where should I go about [Job, Designer, Manger ??] defining the property for NULL to be HIGH-VALUE or so...I'm totally blind-folded on this and any light on this greatly appreciated..Thanks, Vijay
Null Handling: High Values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In all sorts you can specify a Null Value Position so that nulls sort at the beginning or at the end. There is no capacity when sorting to effect a transformation; the only stages that do this are Modify and Transformer.
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.
Thanks Ray...I had taken care of this before, but couldn't remember on where to handle the NULLS...Thanks againray.wurlod wrote:In all sorts you can specify a Null Value Position so that nulls sort at the beginning or at the end. There is no capacity when sorting to effect a transformation; the only stages that do this are Mo ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Depends where you're doing it. My original answer was from memory. It's Nulls position in the context menu on an input-link sort; have not yet checked the Sort stage.
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.