Discussion Board for collaboration on QlikView Scripting.
i have below script , it work fine.
Binary "C:\Users\Paul Yeo\Dropbox\0_Q_Development\0 Q_QVD\000_qvd_v2044e.qvw";
When i add below script , it does not work :-
RESIDENT sales_table WHERE BRAND_='BECKHOFF';
DROP TABLES sales_table;
I like to know it is Binary load does not support limit data load it is ?
Solved! Go to Solution.
What didn't work? What do you mean with "support limit data"?
After a binary load which is loading the entire datamodel from another qvw you could add further data and you could remove data - of course quite easily with dropping from tables and fields but your approach with loading a resident-table, filtering it and drop the origin should work as well as other approaches like inner join/keep loadings to remove unwanted records.
I try again , this time i restart my note book , as you can see from the screen shot below . i still get the error , i believe it is due to the script issue .
Follow the below steps:
1.Please copy the 000_qvd_v915.qvw any of the folder , outside the drop box.Reload/debug the application.
If it is success,
Copy the exact path name as shown below example:
Binary "C:\Qlikview\Project\Emp\000_qvd_v915.qvw"; // 1 yr
Hope this will Helpful. Thank you.
Yes it work fine now , I make a mistake , i Binary Load the Binary data. After i change to read none binary file , it work fine now. Thank you for your patience.