Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

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
Arjunarao
Not applicable

Re: Binary load does not support limit data load ?

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

8 Replies
marcus_sommer
Not applicable

Re: Binary load does not support limit data load ?

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

Arjunarao
Not applicable

Re: Binary load does not support limit data load ?

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

Arjunarao
Not applicable

Re: Binary load does not support limit data load ?

Hi,

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

paulyeo11
Not applicable

Re: Binary load does not support limit data load ?

Hi Sir

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

error again.png

Arjunarao
Not applicable

Re: Binary load does not support limit data load ?

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

paulyeo11
Not applicable

Re: Binary load does not support limit data load ?

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

Arjunarao
Not applicable

Re: Binary load does not support limit data load ?

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
Not applicable

Re: Binary load does not support limit data load ?

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