Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adamgaox
Creator
Creator

Syn Keys Between Tables

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.

GENERATE.PNG.png

2 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable

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