data manipulation

[Anonymous]

Hi,

I need to do some manipulations in script in a small QV-file after the big QV-file has been reduced and distributed by the QV Publisher.

I downloaded a small QV-file (which was created by the Publisher in the process of Reduce and Distribute) to my desktop computer and opened the file in the QlikView desktop version. I see that the edit script dialog became empty after the process of Reduce and Distribute.

Now I need to do some manipulations, actually I need to drop a table and to rename some values in a field. But when I refer to the by its name, there's an error message: 'Table was not found'. However, in the table viewer I can deffinitely see that the table exists.

Could you please advice anything?

Thank you in advance,

Larisa

[swuehl]

Maybe use a BINARY LOAD statement to include the data model of the reduced file, then apply the DROP table statement?

[Anonymous]

I tried it.

At the beginning of the script I put the statement: "binary load table Clients;". I'm sure that the table Clients exists in the model. But I got an error message again.

[swuehl · Accepted solution]

A binary load will load a qvw, not a table.

Binary ReducedFile.qvw;

[Anonymous]

I tried it.

1) I opened the file 'lPC_AGENCY_A_edited.qvw' in QlikView

2) I put the statement: Binary lPC_AGENCY_A_edited.qvw;

3) Then I pressed 'reload'.

4) The error message appeared:

'Cannot open file 'F:\test_QV\post-campaign в интернете\demo_version\lPC_AGENCY_A_edited.qvw'

binary lPC_AGENCY_A_edited.qvw'

[krishna_2644]

As Sweuhl suggested, try doing a binary load.

Binary [FileLocation\FileName.qvw];       

drop table Clients;

eg: Binary [c:\users\desktop\qvdev\Application.qvw];

      drop table Clients;

[krishna_2644]

Do u have any section access defined?

[Anonymous]

There's no section access in my file. Moreover, in Document Properties/Security section Reload is ON.

Still I get an error message:

Binary Load is not allowed on 'F:\test_QV\post-campaign в интернете\test.qvw'

What can cause the error?

Thank you in advance

[jonathandienst]

I dont think that binary load can load itself. Create a new QVW and then add the

Binary lPC_AGENCY_A_edited.qvw;

Now in that script you can manipulate the data model at will - drop tables, add new tables, reduce the data etc.

(Unless of course 'Prohibit binary load' was set on the distributed file)

[jonathandienst]

>>Binary Load is not allowed on 'F:\test_QV\post-campaign в интернете\test.qvw'

You will have to engage with the developer/administrator to turn off the "Prohibit Binary Load" option on Document Properties of the source file (not your distributed file). This is turned on for security purposes to prevent manipulation of the data.

Or you will need to get a special version dropped for your purposes.