topic Loading only Field Names with no data in QlikView

Loading only Field Names with no data

Fri, 27 Jan 2012 00:39:05 GMT

Hi Everyone,

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).

Thanks

gussfish — Fri, 27 Jan 2012 02:27:48 GMT

Hi,

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

table

So, you should be able to use these together to load-in the names of all

your table's fields.

Angus.

perumal_41 — Fri, 27 Jan 2012 07:08:17 GMT

Hi,

Try Below Script helpful for U

Load * Resident tablename where 1=2;

try this script.

Regards,

Perumal.A

Sat, 28 Jan 2012 17:26:32 GMT

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.

Cheers

Mon, 30 Jan 2012 21:44:01 GMT

Thanks so much. That was the answer I was looking for.

Regards.

Mon, 30 Jan 2012 21:45:39 GMT

Thanks Angus, so much. You answer was really helpful.

Regards.

Mon, 30 Jan 2012 21:46:14 GMT

Thanks Pavol fpr your prompt response. You suggestion worked for me.

Regards.