Using If Else in Script

Thu, 13 Nov 2014 12:07:51 GMT

I am loading all the QVDs present in a folder. The QVDs have year suffixed to it's name. e.g. Sample_2012.qvd, Sample_2013.qvd and so on...

I have to store latest two years qvds in one folder and the QVDs prior to 2 years in another folder. How do i do that?

Re: Using If Else in Script

Anonymous — Thu, 13 Nov 2014 14:23:41 GMT

Hi Asma

Below is the code which will work for you

Temp:

load Distinct FileBaseName() as Filename

from

C:\Users\Desktop\Temp\*.qvd(qvd);'This path is where QVD's are placed

For i = 1 to NoOfRows('Temp')

let filename=FieldValue('Filename',$(i));

if(right('$(filename)',4)='2014') then

$(filename):

load

* From C:\Users\Desktop\Temp\$(filename).qvd(qvd);

let path='C:\Users\Desktop\Temp\currentYear\'&'$(filename)'&'.qvd(qvd)';

store $(filename) into $(path);

drop table $(filename);

ELSEIF(Right('$(filename)',4)<2014)then

$(filename):

load

* From C:\Users\Desktop\Temp\$(filename).qvd(qvd);

let path='C:\Users\Desktop\Temp\previousYear\'&'$(filename)'&'.qvd(qvd)';

store $(filename) into $(path);

drop table $(filename);

end if

Regards

Harsha