Filter issue>>>>>Urgent

[nagarjuna_kotha]

Hi all,

I have field on year.in that i have 2011,2012,2013,2014,2015.

I want only 2014 and 2015.how to do in script level.

Give me solution on ASAP

Regards,

Nagarjuna

[Anonymous]

Hi,

You can add a where clause in your load script.

Load * from table

where match(year,2014,2015)

Regards,

Greeshma

[#3]

Hi Nagarjuna,

You can achieve it by this way also,

LOAD year

FROM

D:\Vrushali\QVDs\tab.qvd

(qvd)where year>2013;

Regards,

Vrushali.

[#4]

if(match(year,2014,2015),year);

[#5]

if(match(year,2014,2015),year);

[amit_saini · Accepted solution]

Hi,

Try this:

LOAD year

FROM

D:\Vrushali\QVDs\tab.qvd

(qvd)

Where match(Year,'2014','2015') ;

Thanks,

AS

[nagarjuna_kotha]

Thank you for ur quick reply.

Regards,

Nagarjuna

[amit_saini]

Cheers