topic Re: Binary load does not support limit data load ? in QlikView

Binary load does not support limit data load ?

paulyeo11 — Sat, 05 Sep 2015 09:10:30 GMT

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

Re: Binary load does not support limit data load ?

marcus_sommer — Sat, 05 Sep 2015 09:42:53 GMT

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

Re: Binary load does not support limit data load ?

qlikviewwizard — Sat, 05 Sep 2015 10:42:11 GMT

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

Re: Binary load does not support limit data load ?

qlikviewwizard — Sun, 06 Sep 2015 02:01:49 GMT

Hi,

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

Re: Binary load does not support limit data load ?

paulyeo11 — Sun, 06 Sep 2015 02:11:39 GMT

Hi Sir

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

Re: Binary load does not support limit data load ?

qlikviewwizard — Sun, 06 Sep 2015 02:25:10 GMT

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

Re: Binary load does not support limit data load ?

paulyeo11 — Sun, 06 Sep 2015 07:03:37 GMT

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 .

Re: Binary load does not support limit data load ?

qlikviewwizard — Sun, 06 Sep 2015 07:23:29 GMT

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,

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.

Re: Binary load does not support limit data load ?

paulyeo11 — Sun, 06 Sep 2015 07:57:43 GMT

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