Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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