Use technical fields in script

[Anonymous]

Hello,

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

Thks

Vincent

[#2]

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

[hic · Accepted solution]

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

[Anonymous]

thks for replies.

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

Regards