Syn Keys Between Tables

[adamgaox]

Hi all,

When I learn QlikView Data Model,I've seen a link between table like this.

General,QlikView create syn keys between table.

How can I generate the link between the green and blue?

What's the difference between this relation and the syn relation?

Thanks in advance.

[jagan]

Hi,

If you have more than one column name common in both the tables then the Synthetic keys are formed, it is not an issue with Synthetic keys.  But it is a good practice to remove those if any.  We can solve this by using Concatenate() or Link tables

Try like this using LinkTable

Table1:

LOAD

Column1,

Column2 & Column3 AS Key,

Column2,

Column3

FROM Table1;

Table2:

LOAD

Column4,

Column2 & Column3 AS Key,

Column2,

Column3

FROM Table1;

LinkTable:

LOAD DISTINCT

     Key,

     Column2,

     Column3

FROM Table1;

Concatenate(LinkTable)

LOAD DISTINCT

     Key,

     Column2,

     Column3

FROM Table2;

Using Concatenate:

Data:

LOAD

*

FROM Table1;

Concatenate(Data)

LOAD

*

FROM Table2;

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Mr Black,

I have created a tutorial on linking tables via keys that you might find useful: QlikView 11 Developer Tutorial - part 17

Mike