Discussion board where members can get started with QlikView.
How are you all?
Can someone please tell me how do I load only the fieldnames in a table from a resident table.
I need no data. All I need are the fieldnames(Names allocated in the resident table).
Solved! Go to Solution.
there are a couple of helpful functions you'll find in the Table
Functions section of the Reference Manual:
FieldName(n,'TableName') - gives you the name of the (n)th field
in your table.
NoOfFields('TableName') - gives you the number of fields in your
So, you should be able to use these together to load-in the names of all
your table's fields.
The where clause
Where RecNo() = 0;
also worked to load only tables and fields with no data and returned this
If you need to work with the table names and field names in QV objects (i.e. list boxes) then use $Table and $Field system fields.
In this example I counted number of unique values in each field.