binary load with different dateranges

[#1]

Hi,

Unfortunately I can not find anything suitable to my problem. Therefore, your expertise and assistance is required.

I have a complete qvw file includes all datarows from year 2007 - today. This file is a binary qvw for several

Applications. I want all the applications with different periods of the binary file upload qvw.

An example:

The Binary qvw contains all records from 2007 to today.

1. The application App1 requires only the records from 2010 - today

2. The application App2 includes only the records from 2012 - today

3. and the third App3 includes only the records from the previous year

How can I prepare this to meet the described requirement without the need for 3 separate qvw binary files ?

I am grateful for any help or small example.

With best regards,

[stephencredmond]

Hi,

You can't modify the records that are loaded by a binary load.

Therefore, you will need to load all of the records and then remove them - using an inner join is probably the best way - once they are in.  E.g.:

Binary myfile.qvw;

Inner Join Load * inline [

Year

2011

2012

];

(You would probably create this table more dynamically).

Regards,

Stephen

[#3]

Hi Stephen,

thank you for help. But it dont works. Here an exmple of my qvw file.

I want to drop all records with with the month of 4 (April) .

Can you show me this on my attached example file ?

Thank you very much

Best Regards

[stephencredmond · Accepted solution]

Hi,

Try this:

Inner Join ([Banf 2011$])

Load Distinct

          Monat

Resident

          [Banf 2011$]

Where Num(Monat) <> 4;

Regards,

Stephen

[#5]

Great !

Thank you very much

Regards,

Hon