Page 2 of 2
Posted: Tue Jun 02, 2009 5:46 am
by Swaruparani
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
Posted: Tue Jun 02, 2009 7:27 am
by Sainath.Srinivasan
What is the datatype for the column?
What if you set the null value as 'Unknown' ?
Posted: Tue Jun 02, 2009 9:51 am
by samsuf2002
Are you able to view those records when you click "view data" in sequential file. What is the job design ?
Posted: Wed Jun 03, 2009 12:24 am
by Swaruparani
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.
Posted: Wed Jun 03, 2009 1:00 am
by dspxlearn
By viewing the data from the sequential file are you seeing a single space or multiple spaces or nothing for that paticular record?