topic Re: field names in QlikView

field names

Tue, 19 Jun 2012 07:17:02 GMT

hi all,

is there a way to automatically name the fields loaded in a load script with

as TABLENAME.FIELDNAME

If i load multiple tables that might have some fields with the same name i want to prevent the creation of keys without having to look at each field and check if this field name already exists...

thanks a lot!

Re: field names

Tue, 19 Jun 2012 07:22:00 GMT

Hi,

You can use

QUALIFY ;

write this before the load statement.

this will qualify all the fields with thr respective table names.

i hop this will solve ur need.

Re: field names

Tue, 19 Jun 2012 07:23:24 GMT

QUALIFY *;

table name:

load script.....

this will rename all fields like "table name.field name"

Re: field names

jonathandienst — Tue, 19 Jun 2012 07:23:43 GMT

The QUALIFY statement does that. If you want all field names to be qualified with table names, the use:

QUALIFY *;

For specific fields, use the list of field names in the QUALIFY statements.

Turn off the qualification with UNQUALIFY *.

Hope that helps

Jonathan