INTERVAL MATCH

[upaliwije]

Hi,

I have created a QV document with claim and premium data where I want to match Loss date of a claim between period from and period to of a policy. But I do not get desired results .

All claim are matched disregarding policy period

Premium is show against each record where It should be shown in a separate row.

Kindly have a look at my QV document and advise

[sunny_talwar]

Can you see what happens when you make this change:

CLM_Data:

First 200

LOAD POLICY_NO,

    // date(PERIOD_FROM,'DD-MMM-YYYY')AS  PERIOD_FROM,

   //date( PERIOD_TO,'DD-MMM-YYYY')AS   PERIOD_TO,

     CLAIM_NO,

      CRE_PAID_AMOUNT AS PAID_AMOUNT,

     Date(Floor( LOSS_DATE),'DD-MMM-YYYY')AS LOSS_DATE,

     PAID_DATE,

   RISK

FROM

PRE_CLM.QVD

(qvd)

WHERE BCOD='NI00'

;

PRE_DATA:

FIRST 200

LOAD

     PERIOD_FROM,

     PERIOD_TO,

     POLICY_NO,

   CLA_CODE,

     PRD_CODE,

     BCOD,

    //REN,

     PREMIUM

FROM

SORTED_POLICIES.QVD

(qvd)

WHERE BCOD='NI00';

IntervalMatch:

INTERVALMATCH(LOSS_DATE,POLICY_NO)

LOAD PERIOD_FROM,

     PERIOD_TO,

     POLICY_NO

     RESIDENT PRE_DATA;

[upaliwije]

Thanks Sunny

Still the result is same No change

[bohravanraj]

Please Refer attach QVW

[upaliwije]

Thanks

Premium is not shown there