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.