RENAMING CLASS CODE

[nevilledhamsiri]

Dear Members,

I have list of class codes such as below

CH,PP,SA,HH,M3,M4,MC,MS,TC  etc

Out of this list, CH,PP,SA to be re designated as PP & other codes to be remaining as it is. Once this is done the new field created should appear like below

PP,HH,M3,M4,MCMS,TC

Premium under PP,CH & SA should come as an aggregated total under PP class & balance to be shown under other class as they are.

Hope you may send me the formula to be used. I used if match function but my desired out put wont come as it converts all class codes s PP.

Thanks

[nevilledhamsiri]

Dear Members,

Please look in to this

Thanks

Neville

[Siva_Sankar · Accepted solution]

Hi Neville,

Attached example.

Temp:
LOAD CLASS_CODE,
PREMIUM
FROM
C:\Users\A0703003\Downloads\CLASS_CODE.xlsx
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
Fact:
Load
if(CLASS_CODE='CH' or CLASS_CODE='SA','PP',CLASS_CODE) as CLASS_CODE,
PREMIUM
Resident Temp;

Drop table Temp;

[nevilledhamsiri]

Thanks siva

Your reply helped me to resolve my issue.

Neville