What is Synthetic Key?

[#1]

What is Synthetic Key?

[ramkrishna86 · Accepted solution]

When there is more than one field that link two tables, you will get a synthetic key in QlikView.

[#3]

Hi,

When two or more than one field is associated between tables then synthtic key and table is formed .

it is better to avoid it

various ways we can avoid it.

1)renaming the fields

2) commenting the filelds.

3)joining

4)concatenate

5)complex keys

6)link table find attached  ppt will  be helpful to you.

regards

Mahesh