Exists

[upaliwije]

I have two data table in my QV load script.

Claim 1 and claim2

I want to load data from claim2 if a matching record exists in claim2 table. Matching field is RISK

I have written following script but it does not work correctly.

claim1:

LOAD VEHICLE_N0 AS RISK,

     NOC,

     PROVISON,

     PAID

FROM

(ooxml, embedded labels, table is Sheet1);

load

POLICY_NO,

CLAIM_NO,

RISK,

PAID_AMOUNT

  Resident CLAIM2

where Exists (RISK) ;

pls correct my syntax if it wrong

[upaliwije]

CLAIM2:

sql

select  RISK

POLICY_NO,

CLAIM_NO,

PAID_AMOUNT

from act_claim;

claim1:

LOAD VEHICLE_N0 AS RISK,

     NOC,

     PROVISON,

     PAID

FROM

(ooxml, embedded labels, table is Sheet1);

load

POLICY_NO,

CLAIM_NO,

RISK,

PAID_AMOUNT

  Resident CLAIM2

where Exists (RISK) ;

[upaliwije]

Still not working

[avinashelite · Accepted solution]

try like this

CLAIM2:

sql

select  RISK

POLICY_NO,

CLAIM_NO,

PAID_AMOUNT

from act_claim;

claim1:

LOAD VEHICLE_N0 AS C_RISK,

     NOC,

     PROVISON,

     PAID

FROM

(ooxml, embedded labels, table is Sheet1);

noconcatenate

load

POLICY_NO,

CLAIM_NO,

RISK,

PAID_AMOUNT

  Resident CLAIM2

where Exists (C_RISK,RISK) ;

• Exists

[upaliwije]

Thanks all