I have picked up the following script -
ClaimsCheck:
MAPPING load Ref,'No' as Ind
resident ClaimsIndicator
where PrepareClaimsMotor.TotalIncidents=0 AND PrepareClaimsMotor.TotalIncurredAmt=0 ;
drop table ClaimsIndicator;
left keep (UnboundPeersMotor) load [UnboundPeersMotor.Marsh Ref],applymap('ClaimsCheck',[UnboundPeersMotor.Marsh Ref],'Yes') as ClaimsInd
resident PrepareClaimsMotor;
left keep(UnboundPeersMotor)LOAD ClientRef,
ClaimRef,
ClientRef&'/'&date(yearstart(NotificationDate),'YYYY') as ClaimsCauseKey,
ClaimPaymentRef,
CostType,
Cause,
Type,
Section,
Status,
ClientAtFault,
NCDImpact,
NotificationDate,
LossFromDate,
SettlementDate,
PaymentDate,
ExcessDeducted,
Paid,
Recovered,
Reserved
FROM
//
$(vDataPath)Jelf Motor Risks.xlsx
(ooxml, embedded labels, table is [Claims Casue of Loss])
where Type='Motor';
And I've been asked to add the following -
LOAD ClientRef,
ClaimRef,
ClientRef&'/'&date(yearstart(NotificationDate),'YYYY') as ClaimsCauseKey,
ClaimPaymentRef,
CostType,
Cause,
Type,
Section,
Status,
ClientAtFault,
NCDImpact,
NotificationDate,
LossFromDate,
SettlementDate,
PaymentDate,
ExcessDeducted,
Paid,
Recovered,
Reserved
FROM
$(vDataPath)Claim_EL.xlsx
(ooxml, embedded labels, table is [Claim_EL])
where Type='Employers Liability';
So effectively it's the same fields but from a different source. Do I just concatenate or do I Keep Left? Or what?
