Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Binary load does not support limit data load ?

Hi All

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 :-

NewFilteredTable:

NOCONCATENATE

LOAD *

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 ?

paul

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

Hi Please close all the folders, files and repeat the same. Thank you.

View solution in original post

8 Replies
marcus_sommer

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.

- Marcus

qlikviewwizard
Master II
Master II

It will support. Can you demonstrate your issue clearly. Please attach the sample files too. Thank you.

qlikviewwizard
Master II
Master II

Hi,

Close all the opened applications , open the applications,reload again.

paulyeo11
Master
Master
Author

Hi Sir

I am using ver 9 , after close and open again still get error massage.

error again.png

qlikviewwizard
Master II
Master II

Hi Please close all the folders, files and repeat the same. Thank you.

paulyeo11
Master
Master
Author

Hi Sir

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 .

close all.png

qlikviewwizard
Master II
Master II

Hi,

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,

2.

Copy the exact path name as shown below example:

C:\Qlikview\Project\Emp\000_qvd_v915.qvw

Binary "C:\Qlikview\Project\Emp\000_qvd_v915.qvw";  // 1 yr

Hope this will Helpful. Thank you.

paulyeo11
Master
Master
Author

Hi Sir

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.

Paul