Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Please help me to achieve these objectives!
A. I need to separate records based on the period_from field. (Please make a Flag in the script to pick records which are made after 02/28/2018 (February 28th 2018).
B. As per the formula written in the script to convert class_codes such as CH,SA as PP simmerly I need to includes all other codes to the class_code1, can it be done at once such as making all other classes to be kept as it is like that rather than including all classes in to the formula.
Thanks in advance
Neville
Not sure what issue are you facing while creating the flag or adding the class codes.
For period flag you can simply use - if(PERIOD_FROM> '2/28/2018',1) as PeriodFlag in the resident or preceding load.
attachment
attachment
Also If I am to do a grouping based on the Debtor codes what function to be used?
Hope one of our Officer may help on this.
Thank very much
Neville
Not sure what issue are you facing while creating the flag or adding the class codes.
For period flag you can simply use - if(PERIOD_FROM> '2/28/2018',1) as PeriodFlag in the resident or preceding load.
Hi Neelam, Thanks a lot. That works fine. Could you please help me to achieve my 2nd output.What I really need is following classes are coming under class code which is a dimension. I have applied following function to convert SA,CH in to PP because these two classes (CH & SA being designated as PP. Can i extend this function to designate all other class_codes as it is. once this is done, only following classes to be appeared. Such as MC,FR,TC,M4,MS,PP,EN,HH,M3,TT.
Any help please
Thanks neville
IF(MATCH(CLASS_CODE,'SA','CH','PP'),'PP')AS CLASS_CODE1
CLASS_CODE |
MC |
FR |
TC |
M4 |
MS |
CH |
EN |
PP |
HH |
M3 |
TT |
Yes, you can add all the above mentioned class names in the existing function -
IF(MATCH(CLASS_CODE,'SA','CH','PP','MC','FR','TC','M4','MS','EN','HH','M3','TT'),'PP')AS CLASS_CODE1
If that is applied all classes become pp, I need SA, CH & PP to be designated as PP & keep all other classes as it is
Dear Neelam,
One more issue wish to be clarified. I the attachment you find various Debtor codes. If I am to arrange those unique codes separately with the total related premium due to them, what kind of function to be made. Can it be possible in the script or in the front end. Any idea please