Hi friends,
How can i write an expression in load script.
i have used an expression using SET ANALYSIS in front end.Due to performance lag i need to change my expression to load script.
My Expression is
(if((CLM_STATUS <>'C' or (CLM_STATUS='C' and Today()<=CLM_CLOSE_DT))and CLM_STATUS<>'R' and (CE_CLOSE_YN <> '1' or (CE_CLOSE_YN= '1' and CE_CLOSE_DT>Today())),
(sum({<CS_EST_TYPE={"=CS_EST_TYPE=1"},CE_DT={"=CE_DT<=Today()"},
CE_PARTY_ID={"=CE_PARTY_ID=CS_PARTY_ID"},CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"}>}AMOUNT)
here i'm comparing the fields from three tables A, B, C.
how can i keep resident for one and another table.
Please anyone suggest me how to do it so..
Thanks and Regards,
Krishna