Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi,
Try this:
Inner Join ([Banf 2011$])
Load Distinct
Monat
Resident
[Banf 2011$]
Where Num(Monat) <> 4;
Regards,
Stephen
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
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
Hi,
Try this:
Inner Join ([Banf 2011$])
Load Distinct
Monat
Resident
[Banf 2011$]
Where Num(Monat) <> 4;
Regards,
Stephen
Great !
Thank you very much
Regards,
Hon