topic Re: set primary key on loaded table in QlikView

set primary key on loaded table

stefano_pernat — Thu, 19 Feb 2015 16:04:00 GMT

Hi all,

I'm new to QlikView,

is it possible to set a field explicitly as primary key on a loaded table in order to make an association with another table?

Re: set primary key on loaded table

sunny_talwar — Thu, 19 Feb 2015 16:14:06 GMT

For making joins between tables you need to give the field the same name in both the tables and QlikView will itself form the association. For instance:

Table1:

LOAD xyz,

Date

FROM someTable.xlsx;

Table2:

LOAD xyz,

Year

FROM anotherTable.xlsx

These two tables will automatically show a association on the field XYZ.

HTH

Best,

Re: set primary key on loaded table

buzzy996 — Thu, 19 Feb 2015 16:39:33 GMT

the above explanation is absolutely right,

if ur case is like this then u can try the below one,

Table1:

LOAD xyzaaaa as Key1,

Date

FROM someTable.xlsx;

Table2:

LOAD xyz as Key1,

Year

FROM anotherTable.xlsx

Re: set primary key on loaded table

mukesh24 — Thu, 19 Feb 2015 16:43:46 GMT

Hi stefno,

above examples is right.. In qlikview if u want to do assosiation between 2 table simply alias field to common name.

For Ex:-

Student:

LOAD RollNo as Key1,

StudDate

FROM Student.xlsx;

Mark:

LOAD SRN as Key1,

Marks

FROM Marksheet.xlsx

Regards,

Mukesh Chaudhari

Re: set primary key on loaded table

robert_mika — Thu, 19 Feb 2015 17:07:18 GMT

One more way when you have more that one column with the same name:

Do you Qualify?

Re: set primary key on loaded table

hic — Thu, 19 Feb 2015 21:57:54 GMT

The bottom line is that QlikView doesn't care about which the primary key is. The only thing that matters, is what the name of the field is. If it is the same in two tables, it's a key. Full stop.

So make sure that

you name keys the same in different tables.
you name non-keys differently in different tables (e.g. fields like Comment, Remark, and Description)

HIC