Load qvd automatically based on day basis

[#1]

Hi,

I am storing a qvd everyday in a folder from Monday to Friday.

My requirement is I would like to use the qvd on day basis for instance today is monday, so the report has to load the Moday.qvd automatically if the day is Tuesday means it has to load the Tuesday.qvd in the report.

Currently as I am using for each day a report, that is taking more space, so I need to avoid this.

Thanks in advance

Regards

Chriss

[#2]

try according to this

Temp:

LOAD * from table;

LET vDay = Date(Today(),'wwww');

STORE Temp into D:\$(vDay).qvd;

[Anonymous]

Can you make it more clear why is you daily create a new qvd?

why not in on transaction table?

please make it more clear...

Regards,

anant

[#4]

Hi Vishwa,

Thanks for your reply

I tried what you said but I can not get the solution, there is a specific foler the 5 days qvd will be stored, if today is monday means the script should load automatically Monday.qvd as the same for the rest of days.

Regards

Chriss

[#5]

your script should load automatically, then you must make Batch file and then by the use of task schedular you can run your script automatically by the use of my previous posted code.

Regards

[#6]

You can try like this...

IF WeekDay(Today()) = 'Mon' Then

  LET vQVDPath = 'D:\Mon\';

ELSEIF WeekDay(Today()) = 'Tue'

  LET vQVDPath = 'D:\Tue\';

ELSEIF WeekDay(Today()) = 'Wed'

  LET vQVDPath = 'D:\Wed\';

ELSE

LET vQVDPath = 'D:\Thu\';

TableName:

LOAD Field1,Field2 From '$(vQVDPath)'\filename.qvd;

[#7]

Hi Viswarajan,

Hope I am not clear to you.

I have already created a QVD in a folder from Monday to Friday that is I have now 5 QVD's in the name of

Monday.qvd, Tuesday.qvd.

Now I am trying to load the if today() is Monday means the script has to load Monday.qvd, suppose if today() is Tuesday means Tuesday.qvd has to reload.

Hope its clear...

Regards

Chriss

[#8]

write your qvds according to this.

IF Date(Today(),'wwww')='Monday' then

load * From table1;

store tabl1 into D:\Monday.qvd;

ELSEIF Date(Today(),'wwww')='Tuesday' then

load * From table2;

store tabl2 into D:\Tuesday.qvd;

ELSEIF Date(Today(),'wwww')='Wednesday' then

load * From table3;

store table3 into D:\Wednesday.qvd;

ELSEIF Date(Today(),'wwww')='Thursday' then

load * From table4;

store table4 into D:\Thursday.qvd;

ELSEIF Date(Today(),'wwww')='Friday' then

load * From table5;

store table5 into D:\Friday.qvd;

ELSE

EXIT Script;

[#9]

Did you try this?

[#10]

If I understand it correct, then he has already the QVD-s, he just wants to load from the right QVD on the right weekday.

Smth like this:

IF Date(Today(),'wwww')='Monday' then

load * D:\Monday.qvd;

ELSEIF Date(Today(),'wwww')='Tuesday' then

load * D:\Tuesday.qvd;

*****************

ELSEIF Date(Today(),'wwww')='Friday' then

load * From D:\Friday.qvd;

ELSE

EXIT Script;