Null handling in transformer

Swaruparani · Post by **Swaruparani** » Tue Jun 02, 2009 5:46 am

Hi Shalini,

pls try this one in transformer,this is working

If IsNull(DSLink3.inputcolumn) Then 'UNKNOWN' Else If trim(nulltoempty(DSLink3.inputcolumn)) ='' Then 'UNKNOWN' Else DSLink3.inputcolumn

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 02, 2009 7:27 am

What is the datatype for the column?

What if you set the null value as 'Unknown' ?

samsuf2002 · Post by **samsuf2002** » Tue Jun 02, 2009 9:51 am

Are you able to view those records when you click "view data" in sequential file. What is the job design ?

Swaruparani · Post by **Swaruparani** » Wed Jun 03, 2009 12:24 am

Hi Shalini,

This one is working,u can try this:

If IsNull(DSLink3.inputcolumnn) Then 'UNKNOWN' Else If trim(nulltoempty(DSLink3.inputcolumnn)) ='' Then 'UNKNOWN' Else DSLink3.inputcolumnn

Thanks.

dspxlearn · Post by **dspxlearn** » Wed Jun 03, 2009 1:00 am

By viewing the data from the sequential file are you seeing a single space or multiple spaces or nothing for that paticular record?