topic SystemTables of $Field System Variable in QlikView

SystemTables of $Field System Variable

Thu, 21 Jan 2010 13:06:31 GMT

Hi,

I know that systemvariable $Field represents all fields of loaded application. I also know that the $Table variable gives the corresponding table(s).

Wo do I act in script, if I only want the Fields of a specific table?

something like this:

tmpTableFields:

LOAD $Field FROM $Tables WHERE $Table = '<specific table name>';

What is the SystemTableName of $Fields ($Tables in upper example)? And is the where clause $Table = '<specific table name>' correct?

Any suggestions?

SystemTables of $Field System Variable

Thu, 21 Jan 2010 16:22:02 GMT

As far as I know you cant use the systemvariables in the script.
Have a look at the table-functions NoOfFields & FieldName.
Used together with while and iterno you should be able to get the desired result.

/Fredrik

SystemTables of $Field System Variable

rwunderlich — Thu, 21 Jan 2010 16:54:57 GMT

I don't think $Table and $Field are available until the script has finished. Instead, use the functions

NoOfFields('tableName')

and

FieldName(num'tableName')

to get a list of fields.

-Rob