Issue with Error() in informatica -- Need help

86ae2cc6-f9cb-4248-b028-26845c300375

1. 1. I have the below expression in output port:

IIF(ISNULL( IN_ORG_DESC ),

ERROR('ABC~W_INT_ORG_DS.csv~ORG_DESC~IS NULL FOR~'||IIF(ISNULL(ROW_NUM),'W_INT_ORG_DS.csv - ROW  NUMBER '||ROW_NUM,''||ROW_NUM )),  IN_ORG_DESC)

1. 2.The thing is, when i donot have any null values for field 'IN_ORG_DESC ' , all the rows are loaded into target table successfully.

1. 3.When i get null value for the field 'IN_ORG_DESC ', the respective record is loaded into informaitca pre built error table, with the following error mesage:

Transformation [EXP_Extract_WC_Basic_Data_Fact] had an error evaluating output column [IN_ORG_DESC ]. Error message is [<<Expression Error>> [ERROR]:

ABC~WC_BASIC_DATA_F.csv~IN_ORG_DESC ~IS NULL OR LOOK UP COLUMN W_INT_ORG_D.INTEGRATION_ID IS NULL FOR ROW NUMBER~1

... u:ERROR(u:CONCAT(u:'ABC~WC_BASIC_DATA_F.csv~IN_ORG_DESC ~IS NULL OR LOOK UP COLUMN W_INT_ORG_D.INTEGRATION_ID IS NULL FOR ROW NUMBER~',u:IIF(i:ISNULL(u:'1'),u:

CONCAT(u:'WC_BASIC_DATA_F.csv - ROW  NUMBER ',u:'1'),u:CONCAT(u:'',u:'1'))))].

Ideally it should load as: ABC~WC_BASIC_DATA_F.csv~IN_ORG_DESC ~IS NULL OR LOOK UP COLUMN W_INT_ORG_D.INTEGRATION_ID IS NULL FOR ROW NUMBER~1

Any ideas pls

Thanks,

Veera