topic Re: binary load with different dateranges in QlikView

binary load with different dateranges

Wed, 25 Jan 2012 14:44:25 GMT

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,

binary load with different dateranges

stephencredmond — Wed, 25 Jan 2012 15:32:28 GMT

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

Re: binary load with different dateranges

Thu, 26 Jan 2012 16:11:59 GMT

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

Re: binary load with different dateranges

stephencredmond — Thu, 26 Jan 2012 21:49:48 GMT

Hi,

Try this:

Inner Join ([Banf 2011$])

Load Distinct

Monat

Resident

[Banf 2011$]

Where Num(Monat) <> 4;

Regards,

Stephen

Re: binary load with different dateranges

Tue, 31 Jan 2012 12:09:05 GMT

Great !

Thank you very much

Regards,

Hon