Qvd Records

[#1]

Hi i have a qvd ... witch containes the date and cusid  fileds, in that i has the 3 months of data ..... how to find each month records indiviually

please let me know the answer

[Peter_Cammaert]

Load all data from your QVD, and create a new Month-column based on the date field. That column will show you the month of each record.

Data:

LOAD *, Month(DateField) AS Month

FROM YourFile.qvd (qvd);

If you want to load a single month, add a WHERE clause to your LOAD statement, like in

SET vMonth = 2; // February

Data2:

LOAD *

FROM YourFile.qvd (qvd)

WHERE Month(DateField) = $(vMonth);;

[#3]

Or like this

For i = 1 to 12

SET vMonth = $(i); // February

DataMonth_$(i):

LOAD *

FROM YourFile.qvd (qvd)

WHERE Month(DateField) = $(i);

Store DataMonth_$(i) Into DataMonth_$(i).qvd (QVD);

Next

[#4]

Hi i wanna only 3 months data ... to count .... please tell me the way ....

my filed containes data of 3 months exp 1, 2,3 months of date

so what is the way to count for each and every month indiviually

[Peter_Cammaert]

Use a LOAD with a GROUP BY clause, and add Month to the grouping.

Now you can count, sum, average etc. all other numeric fields in your file and this time per month.