Expression in Load script

[krishna20]

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