IF CONDITION

[upaliwije]

Hi Freinds

I have following condition in my data load script.But I do not get the expected results . There so many C_TYPES but all of them except defined below do not catagarise ito OTHERS catagory but shown seperately. Pls see whether condition is wrong if so correct me.

IF(C_TYPE='ST36','TOTAL_LOSS',IF(C_TYPE='ST06' OR C_TYPE='ST07' OR C_TYPE='ST08','LEGAL','OTHERS')) AS SET_CODE,

[johnca · Accepted solution]

Hi Upali, this should give the results you seek...

IF(C_TYPE='ST36','TOTAL_LOSS',

     IF(C_TYPE='ST06','LEGAL',

          IF(C_TYPE='ST08','LEGAL',

          'OTHERS'))) AS SET_CODE

[upaliwije]

THANKS