Need to get 6 weeks back data

[vardhancse]

Hi All,

Curenntly I have a requirement is that I have a huge voume of data i.e around 3 years of data.

In that I want to create QVD for last 6 weeks data.

Can any one help me out in creating the expression for the same.

Thanks & Regards

Sasi

[#2]

try this

load * from myqvd

where week(date(datefield)) >=week(max(date(datefield))) -6 and week(date(datefield)) <=week(max(date(datefield)))

[er_mohit]

Master:

load * from qvd;

noconcatenate

Transaction:

load *

resident Master

Where week(TempDate)<= Week(Date(Today()))-6 ORDER BY TempDate ASC;

drop table Master;  //if you want then drop it

store Transaction  into E:\tansaction.qvd;

here bold one is My Date Field

hope it helps