DSXchange

Hi

I am trying to assign a null value to a date based on a certain condition in the transformer.

If the score is 1 then the data shld be assigned else the date shld be null in DB.

I am using something like
If score=1 then DSJOB start date else ' '

But its failing. How to handle this scenarios?

thanks

Use the SetNull() function. and make sure the target column is nullable

If you still need help with this, please don't post "something like" what you are doing - post exactly what you are doing so people can provide the proper help. Also note that saying something "is failing" really doesn't give us anything to work with, always a good idea to post (unedited) any error messages you get from a failure.

Also as noted: two quotes is an empty string which is not the same as null so use the SetNull() function instead.

If you try to compare a null value OR using it against a lookup then the record may get dropped.
Regards
Sreeni