DSXchange

Hi,

Iam using a stage variable "SV" and it has data type varchar 255, in derivation field for SV I have given expression as

IF ln1.DIV = '20' then (Trim(ln1.con),4) else SetNull()


When Iam compiling a job it is giving an error saying


Setting null to this non-nullable field: StageVar0_SV.


I need help in this stage variable issue. My question is can I use SetNull function in stage variable, if so how to do that


Thanks,
Somaraju.

The short answer is 'no'. As noted, they are non-nullable.

Use an "In-band null" - a value that is valid for the data type, that represents null and that will not otherwise appear in the data. Convert this to an actual null in a downstream Modify stage using handle_null() or a Transformer stage.