topic Re: Use technical fields in script in QlikView

Use technical fields in script

Anonymous — Thu, 05 Dec 2013 14:07:17 GMT

Hello,

I'd like to know if it's possible to use $Table and $Field in load script

Thks

Vincent

Re: Use technical fields in script

Thu, 05 Dec 2013 14:17:44 GMT

Vincent,

i don't know but here is an example found http://qlikviewnotes.blogspot.fr/2011/02/qvd-questions-and-answers.html

to store all the table into QVDs (a QVD storing only one table, a loop on tables is necessary if you want to export everything).

FOR i = 1 to NoOfTables()

LET vTableName = TableName($(i)-1);

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Fabrice

Re: Use technical fields in script

hic — Thu, 05 Dec 2013 14:49:39 GMT

No, you cannot access the system fields during the script execution. They are created at the end of the script run when the data model is well defined.

But there are a number of system functions, e.g. FieldName() and TableName() that you can access. Check the documentation or try to insert a function in the script.

HIC

Re: Use technical fields in script

Anonymous — Thu, 05 Dec 2013 15:16:19 GMT

thks for replies.

I'm finaly using Loops with TableName() and FieldName()

Regards