Binary load does not support limit data load ?

[paulyeo11]

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

[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]

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

[qlikviewwizard]

Hi,

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

[paulyeo11]

Hi Sir

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

[qlikviewwizard · Accepted solution]

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

[paulyeo11]

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 .

[qlikviewwizard]

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]

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