Please help to solve where condition

[NEHAD]

FinalEDW AS(
select 
PolicyNumber
,InsuranceProduct
,AgencyNumber
,WrittenPremium
,TransactionType 
,AgentNumberCombined
,TransactionNumber
,clunderwritername
,clunderwritingteam
,AgencyName
,NewBusinessPremium
,FieldAreaNo
,AgencyDimensionIdNew
,AccountingDts
,NewBusinessDate
,PolicyProcessDts
,PolicyEffectiveDts
,RawNewBusiness
,PolicyInceptionDtsEDW as InceptionDate
,Cancelled
,TransactionEffectiveDts
,PolicyCancelDate
from Cancel3EDW
where PolicyNumber not in ( select PolicyNumber from CancelledEDW ) 
)

[NEHAD]

Can someone help as it's quite a urgent task.

[PrashantSangle · Accepted solution]

what help do you need in this??

in qlik it is very simple

1st Load Policy Number from CancelEDW

then Load data from Cancel3EDW use where not exist condition for not to load Policy number which in CancelEDW

then Drop table CancelEDW

You Script might be like

CancelEDW:

Load PolicyNumber from CancelEDW;

NoConcatenate

Cancel3EDW:

Load * from Cancel3EDW where not exists(PolicyNumber,PolicyNumber);

Drop table CancelEDW;

Regards,

Prashant Sangle