Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jonesbrown
Creator
Creator

how to Remove synthetic keys give me an example

Hi All 

I am new to Qlikview

how to Remove synthetic keys give me an example 

plz help.

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

3 Replies
siddheshmane
Creator
Creator

Hi,

Hope this helps.

I've created two tables TEST1 and TEST2, Both the tables contain 3 columns. to create an association between two tables we would need one common column in both the tables. However there are situations where there are more than one columns that have same names in both the tables. e.g below.

TEST1:
LOAD
A,
B,
C
RESIDENT TABLE_A;


TEST2:
LOAD
A,
B,
D

Resident TABLE_B;

 

A and B columns will create a synthetic key between the two tables here. To avoid this, i can rename a column from any one of the tables for which i do not want any association. Like say,

 

TEST1:
LOAD
A,
B,
C
RESIDENT TABLE_A;


TEST2:
LOAD
A,
B AS TEMP_COL,
D

Resident TABLE_B;

Now the tables will be associated with only the A column.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Here is my overview of the process of evaluating and removing synthetic keys: 

https://qlikviewcookbook.com/resolving-synthetic-keys/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

 

 

jonesbrown
Creator
Creator
Author

Thank You