Keep left?

kevbrown — Wed, 19 Jul 2017 13:57:28 GMT

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?

Re: Keep left?

aarkay29 — Wed, 19 Jul 2017 14:04:30 GMT

Concatenate my friend If you Keep left there will be synthetic keys in the data model

Re: Keep left?

kevbrown — Wed, 19 Jul 2017 14:09:27 GMT

That's that I thought, however when I did concatenate I didn't get any records pulling through

topic Keep left? in QlikView

Keep left?

Re: Keep left?

Re: Keep left?