topic How to specify key field in load statement in QlikView

How to specify key field in load statement

Tue, 27 Mar 2012 15:02:54 GMT

Hello,

Is it possibile to specify the key field in the load statement of the table?

I don't want that Qlikview automatically set the key fields for the table loaded in the script

Regards

Oronzo

How to specify key field in load statement

jvitantonio — Tue, 27 Mar 2012 15:07:32 GMT

The keys will be set by puting the same field name on 2 tables. Ex:

Table1:

LOAD fieldA, field1 from table;

inner join (Table1):

LOAD field2 as fieldA, field3 from table;

How to specify key field in load statement

Tue, 27 Mar 2012 15:15:31 GMT

Hello,

so if I have 2 table with same field I cannot specify the key field for one of this table?

Regards

Oronzo

How to specify key field in load statement

Tue, 27 Mar 2012 15:24:32 GMT

Qlikview use just the name of the field for linking. When ever you want the fields to be linked use the same field name , other wise use seperate field names. As qlikuser14 illustrated you can use 'AS' keyword to alter the field name.

How to specify key field in load statement

Tue, 27 Mar 2012 15:36:28 GMT

Not as such no, QlikView considers a field named exactly the same in 2 or more tables to be a key. This is because of how QlikView's underlying engine stores data. You can used the Qualify statement to make all fields unique and then the Unqualify statement to specify the fields you want to make a key. You still need to make sure its named the same in both tables though.