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

[crusader_]

Hi,

Syntax seems to be ok for this part of code but it's a bit unusual. Do you want to use Claim2 table further and separately with noname table? Have you ensured that they are not autoconcatenated?

Hope this helps.

Andrei

[Anonymous]

what is done in the script before the part with claim1

any other load with a field named RISK?

then you should use another fieldname e.g. CLAIMRISK

or what is the Problem you are facing?

[upaliwije]

Yes I want to use data deom claim2 table

[upaliwije]

I load data from a sql first and the resulting table is CLAIM2. That is resident table

[Anonymous]

can you post the Statement of your first SQL? does it contain a field named RISK?

[upaliwije]

sql

select  RISK

POLICY_NO,

CLAIM_NO,PAID_AMOUNT

from act_claim;

[crusader_]

What is the exact problem? Can you explain?

Have you checked that your tables Claim2 and 'Resident' did not concatenated?

/Andrei

[avinashelite]

could you post your complete script ?? so that it will be helpful for us to debug the issue

[Anonymous]

this may be the problem

use another field

claim1:

LOAD VEHICLE_N0 AS CLAIMRISK,

     NOC,

     PROVISON,

     PAID

FROM

(ooxml, embedded labels, table is Sheet1);

load

POLICY_NO,

CLAIM_NO,

RISK as CLAIMRISK,

PAID_AMOUNT

  Resident CLAIM2

where Exists (RISK,CLAIMRISK) ;