Can you use multiple where clauses?

[bobbydave]

Original where clause

Load *

FROM
[$(vQVDPath)\E_Finance_Reports_Rep14.QVD] (qvd)
where len(source_country_code)>0 
and ApplyMap('MapFordAgents', source_country_code &'-'& Agent)=1;
;

I want to further reduce the load with Dates greater than 2014

FROM
[$(vQVDPath)\E_Finance_Reports_Rep14.QVD] (qvd)
where len(source_country_code)>0  and where Year(Policy_New_Business.AccountingPeriod) > '2014'

and ApplyMap('MapFordAgents', source_country_code &'-'& Agent)=1;
;

Can you add a 2nd where clause?

[Anonymous · Accepted solution]

No, you can only have one where clause per Load.

[bobbydave]

Thanks for clarifying

[#4]

Hello,

is there a turn around ?

can we have multiple load containing each 1 where clause ?

many thanks !