Null Handling: High Values

vijayrc · Post by **vijayrc** » Wed Oct 18, 2006 12:20 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Oct 18, 2006 4:55 pm

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.

vijayrc · Post by **vijayrc** » Wed Oct 18, 2006 5:59 pm

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

splayer · Post by **splayer** » Tue Oct 24, 2006 11:22 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Oct 24, 2006 2:02 pm

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.