Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NEHAD
Contributor II
Contributor II

Kindly help to resolve this where condition.

[Legacy4]: 
Load  

 

WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE)  as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where POLICYNOLEGACY in (select PolicyNoLegacy from Legacy3 where TransCode_EU = '01' );

Labels (1)
1 Solution

Accepted Solutions
TcnCunha_M
Creator III
Creator III

//Connect to your data base 

Tmp:

Load  * ;

select PolicyNoLegacy

from Legacy3

where TransCode_EU = '01'

 

[Legacy4]: 
Load  

WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE)  as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where  Exists(PolicyNoLegacy,POLICYNOLEGACY);

 

 

drop table Tmp;

As you think, so shall you become.

View solution in original post

2 Replies
TcnCunha_M
Creator III
Creator III

//Connect to your data base 

Tmp:

Load  * ;

select PolicyNoLegacy

from Legacy3

where TransCode_EU = '01'

 

[Legacy4]: 
Load  

WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE)  as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where  Exists(PolicyNoLegacy,POLICYNOLEGACY);

 

 

drop table Tmp;

As you think, so shall you become.
NEHAD
Contributor II
Contributor II
Author

thanks