topic Re: Syn Keys Between Tables in QlikView

Syn Keys Between Tables

adamgaox — Fri, 14 Nov 2014 04:19:58 GMT

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.

Re: Syn Keys Between Tables

jagan — Fri, 14 Nov 2014 04:27:43 GMT

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.

Re: Syn Keys Between Tables

Wed, 26 Nov 2014 22:46:43 GMT

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