Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this:
LOAD year
FROM
D:\Vrushali\QVDs\tab.qvd
(qvd)
Where match(Year,'2014','2015') ;
Thanks,
AS
Hi,
You can add a where clause in your load script.
Load * from table
where match(year,2014,2015)
Regards,
Greeshma
Hi Nagarjuna,
You can achieve it by this way also,
LOAD year
FROM
D:\Vrushali\QVDs\tab.qvd
(qvd)where year>2013;
Regards,
Vrushali.
if(match(year,2014,2015),year);
if(match(year,2014,2015),year);
Hi,
Try this:
LOAD year
FROM
D:\Vrushali\QVDs\tab.qvd
(qvd)
Where match(Year,'2014','2015') ;
Thanks,
AS
Thank you for ur quick reply.
Regards,
Nagarjuna
Cheers