Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Dear Members,
Please look in to this
Thanks
Neville
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;
Thanks siva
Your reply helped me to resolve my issue.
Neville