Hi,
We are using the derivation in stage varibale as
If (IsNull(LNK_SRC.PARTY_NO=1)) Then SetNull() Else LNK_SRC.PARTY_NO.
We are getting compilation error as
"##E IIS-DSEE-TFEV-00026 12:11:59(010) <transform> Error when checking composite operator: Setting null to this non-nullable field: StageVar0_attrib."
Thanks.
SetNull() Function in stage variable
Moderators: chulett, rschirm, roy
Re: SetNull() Function in stage variable
SetNull() function will not work in the stage variables so you have to assign 'NULL' the in the column derivation you have to convert it into setnull().
Note: If you use SetNull() in stage variable you will get the compilation errrors.
Note: If you use SetNull() in stage variable you will get the compilation errrors.
Thanks
Vijay
Vijay
Re: SetNull() Function in stage variable
If I understand your requirement correctly "if the source column is null then 1 else source column". Try the below expression
If IsNull(LNK_SRC.PARTY_NO) Then 1 Esle LNK_SRC.PARTY_NO
Regards,
Ureddy
If IsNull(LNK_SRC.PARTY_NO) Then 1 Esle LNK_SRC.PARTY_NO
Regards,
Ureddy
Reddy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: