Dear Friends
In my load script I have following line which does not execute
if(POL_TYPE='F' AND IsNull(LAST_PERIOD),'N',IF(POL_TYPE='F' AND (LEN(TRIM(LAST_PERIOD)))>0,'R',if(POL_TYPE='A','R',POL_TYPE)))AS POL_TYPE,
Pls see and advise me whether it is wrong. My requirement is as follows
If POL_TYPE='F' and LAST_PERIOD is null POL_TYPE should be 'N'
If POL_TYPE='F' and LAST_PERIOD is not null POL_TYPE should be 'R'
If POL_TYPE='A' POL_TYPE should be 'R'
for other records POL_TYPE=POL_TYPE as recorded in the data table
