DSXchange

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

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.

ray.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 ...

Thanks Ray...I had taken care of this before, but couldn't remember on where to handle the NULLS...Thanks again

ray, just a question. Is the property Null Value Position or Nulls Position? The values are "first" and "last".

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.