topic how to programmaticaly edit the script which describes loading data process in QlikView

how to programmaticaly edit the script which describes loading data process

Tue, 04 Jan 2011 21:58:09 GMT

I can't find in API quide how to programmaticaly edit the script which describes loading data process (the script which is a part of qvw file).
How can it be done? I'm new in QV.

how to programmaticaly edit the script which describes loading data process

Oleg_Troyansky — Tue, 04 Jan 2011 22:10:55 GMT

I must say, - this is not exactly a task for a new developer...

However, if you have to programmatically edit the script, you can approach it in 2 ways:

1. Using $-sign expansions. You can build portions of your script within a variable, and then have them executed using $(var) syntax. For example:

LET vScriptPart = 'LOAD A,B,C RESIDENT MyTable;' ;

$(vScriptPart)

The first line assigns the string to the variable, and the second part executes the statement by substituting the variable name by the string.

2. Using macros and QlikView API. The method for accessing the Script is called doc.Script. Here is an example from the API Guide:

rem ** add new line to script **
set docprop = ActiveDocument.GetProperties
docprop.Script = docprop.Script & "Load * from abc.csv;"
ActiveDocument.SetProperties docprop

how to programmaticaly edit the script which describes loading data process

Wed, 05 Jan 2011 10:42:29 GMT

Thanks for your reply.

how to programmaticaly edit the script which describes loading data process

Mon, 10 Jan 2011 10:26:34 GMT

now I try to programmaticaly create tablebox, add some fields to it and reload data using some script.

unfortunately it does not work. it seems that creating table box and adding fields is not enough.

details in http://community.qlik.com/forums/t/39110.aspx. I would be grateful if you looked at this post...