Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.

1 Solution

Accepted Solutions
rwunderlich
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

jonesbrown
Creator
Creator
Author

Thank You