Left Join Duplication and Storing different tables

Anonymous — Wed, 19 Oct 2016 08:43:28 GMT

Dear experts,

I need a solution about for my issue. I have joined two tables with below script but since PaidDate field record in joined table has 2 different records it makes duplication of Premium field after join. I would exclude Paid Date and get sum of claim amount and solve this problem but. I might use paid date field in other tables.

So how can pass a zero value for the duplicated premium field like writing in a condition if claimsID are same for the previous column value of premium field of this record should be zero ?

Or as a second solution can I keep the table with paid date field as a separate table in my data ?

PolicyData:

LOAD Policy,

Type,

Premium

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join (PolicyData)

LOAD Policy,

ClaimID,

[Claim Amount],

[Paid Date]

FROM

(ooxml, embedded labels, table is Sheet2);

I have attached a sample app for your reference.

Your help will be appreciated.

topic Left Join Duplication and Storing different tables in QlikView

Left Join Duplication and Storing different tables