Left Join Duplication and Storing different tables

[Anonymous]

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.