How to restrict the cases based on the specific time

[nevilledhamsiri]

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

[nevilledhamsiri]

attachment

[nevilledhamsiri]

attachment

[nevilledhamsiri]

Also If I am to do a grouping based on the Debtor codes what function to be used?

[nevilledhamsiri]

Hope one of our Officer may help on this.

Thank very much

Neville

[neelamsaroha157 · Accepted solution]

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.

[nevilledhamsiri]

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

[neelamsaroha157]

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

[nevilledhamsiri]

     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

[nevilledhamsiri]

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