Transformer Constraint

mekrreddy · Post by **mekrreddy** » Thu Oct 29, 2009 7:02 pm

Hello,
I one of our jobs we are comparing date with max of that date field from previous day data, i am using this condition in Tx Constraint. but in our source data we have some records with null values in the date field, and comparision failing because of that, I want to give some value in place of null. so that my comparision does not fail, i want give some (01/01/1900) in place of null,

any idea/suggestion please..

chulett · Post by **chulett** » Thu Oct 29, 2009 9:53 pm

There should be a NullToValue transform in there, if not it would be easy enough to create one. Check NullToEmpty and NullToZero for inspiration.

sajidkp · Post by **sajidkp** » Thu Oct 29, 2009 11:41 pm

If you are querying the source then best thing would be a null handker in the query itself

Like in Sqlserver Isnull(col,'01/01/2009')

chvenkat.v · Post by **chvenkat.v** » Fri Oct 30, 2009 12:46 am

If you problem is solved then
please make this topic as resolved.....