Newbie here, and need help with linking fields

Thu, 28 Apr 2011 20:36:00 GMT

Thu, 28 Apr 2011 22:32:40 GMT

Can you be more specific and provide an example?

Anonymous — Thu, 28 Apr 2011 22:38:38 GMT

Below 2 basic points should get you started:

QlikView joins tables based on field names.
QlikView is case sensitive and the columns from the database needs to be referenced in upper case.

Below example should make it clear:

load PRIMARYKEY1 as ID,

VALUE1 as Value1

sql select primarykey1,

value1

from table1;

load PRIMARYKEY2 as ID,

VALUE2 as Value2

sql select primarykey2,

value2

from table2;

Above 2 tables will be joined based on field ID as we renamed primary key from both tables as ID.

Hope that helps,

Dinesh.

topic Newbie here, and need help with linking fields in QlikView