I have to take out the december data from the data file which i have

[#1]

how to take out the the data of the december i have to filter it and keep it seperate and generate a qvd

[#2]

Hi. If I understood,

you can make your selections (using desktop) and after that go to (menu)

    file

         reduce data

             keep possible values

Try with an older file to test.

Another way is store your data into qvd and read it from another or same (drop table before read) qvw with where clauses to don't load all the data.

Alessandro Furtado.

[#3 · Accepted solution]

You can filter out the Month using where and condition.

i.e.

WithoutDecember:

Load

     Date,

     Field1,

     ...

     from yourTable

     where Month(Date) <> 'Dec';

OnlyDecember:

Load

     Date,

     Field1

     ...

     from yourTable

     where Month(Date) = 'Dec';

or

Create a Table with only December date in it and use 'where exists()'. 

MyFilteredData:

Load

          makedate(2012, 12, IterNo()) as FilterDate

          AutoGenerate 1

          while IterNo() <= 31;

left join(MyFilteredData):

Load

     Date as FilterDate,

     Sales,

     field1,

     ...

     from OrderHistory.qvd //(any source table);

Sean