Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Syn Keys Between Tables

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.

Highlighted
Not applicable

Re: Syn Keys Between Tables

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