Join

[upaliwije]

I have to join two QVD files matching two Fields. Is it possible ?

CLM:

LOAD

        POLICY_NO,

         BCOD,

         PRD_CODE,

         POLICY_PERIOD,

         PREMIUM

FROM

E:\premiumC3.qvd

(qvd)

;

join(CLM)

LOAD

POL_POLICY_NO as POLICY_NO, 

POLICY_PERIOD ,

PRL_DESCRIPTION,

     PPR_PREMIUM,

     PPR_PERCENTAGE

  FROM

E:\PRE_BREAKUP.qvd

(qvd)

Colured in Red are two fields to match before joining table. The above script does not work  Pls advise me

[jonathandienst]

qlikviewwizard wrote:

But If you consider other tables, your may get circular references or synthetic keys.

Disagree - the join eliminates the risk of synthetic keys or circular references for the tables under discussion...

[upaliwije]

Can Pls share code for Apply may in relation to my above script

[qlikviewwizard]

Hi Jonathan, What I mean is by considering other tables which are not mentioned in the script. Thank you.

[qlikviewwizard]

Hi,

Can you please share some sample data. Thank you.

[upaliwije]

Can you please give example script for apply map with POLICY,NO and POLICY PERIOD

[krishna20]

Hi,

Try this,

As per my understanding i did this, if anything wrong excuse and experts will guide.

First you need to create Mapping tables in script tab.

Policy_Map:

Mapping Load

POL_POLICY_NO,

PRL_DESCRIPTION

FROM

E:\PRE_BREAKUP.qvd

(qvd);

Period_Map:

Mapping Load

POL_POLICY_NO,

POLICY_PERIOD

FROM

E:\PRE_BREAKUP.qvd

(qvd);

In another tab load your claim table and write the below script.

CLM:

LOAD

        POLICY_NO,

        ApplyMap('Policy_Map',POLICY_NO,Null()) as PRL_DESCRIPTION,

         ApplyMap('Period_Map',POLICY_NO,Null()) as POLICY_PERIOD,

         BCOD,

         PRD_CODE,

         POLICY_PERIOD,

         PREMIUM

FROM

E:\premiumC3.qvd

(qvd)

;

Regards

Krishna

[sunny_talwar]

Krishna -

I feel that if the join is not working on the POLICY_PERIOD, the same issue will cause a problem in the ApplyMap also. I think the first step would be to make sure that POLICY_PERIOD from two sources are same format, and if they are not make them same format.

What do you think about the above?

Best,

Sunny

[krishna20]

Hi Sunny,

Yes i feel the same thing. We need to check the Policy_No and Policy_Period in the both tables first. Because, insurance is a digging concept. If anything misses in the script , results will be totally different and  client will not satisfies . I suggest

upaliwije‌to attach sample file. Then only we  comes to know whether the data is perfect to implement Join or Apply Map() or any other concept.

Regards

Krishna