topic Re: data manipulation in QlikView

data manipulation

Anonymous — Wed, 14 Oct 2015 12:36:27 GMT

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

Re: data manipulation

swuehl — Wed, 14 Oct 2015 12:40:31 GMT

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

Re: data manipulation

Anonymous — Wed, 14 Oct 2015 13:08:50 GMT

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.

Re: data manipulation

swuehl — Wed, 14 Oct 2015 13:12:01 GMT

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

Binary ReducedFile.qvw;

Re: data manipulation

Anonymous — Wed, 14 Oct 2015 13:19:38 GMT

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'

Re: data manipulation

Qrishna — Wed, 14 Oct 2015 13:20:00 GMT

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;

Re: data manipulation

Qrishna — Wed, 14 Oct 2015 13:21:23 GMT

Do u have any section access defined?

Re: data manipulation

Anonymous — Wed, 14 Oct 2015 13:33:53 GMT

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

Re: data manipulation

jonathandienst — Wed, 14 Oct 2015 13:37:16 GMT

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)

Re: data manipulation

jonathandienst — Wed, 14 Oct 2015 13:40:21 GMT

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

Re: data manipulation

Anonymous — Wed, 14 Oct 2015 13:47:46 GMT

Thank you!