SetNull() Function in stage variable

[srai]

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.

[VijayDS]

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.

[ureddy]

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

[ray.wurlod]

The limitation to have only non-null stage variables is one of a number eased in version 8.5.