topic Re: How many ways to avoid the synthetic keys ? in QlikView

How many ways to avoid the synthetic keys ?

Mon, 02 Sep 2013 17:07:06 GMT

How many ways to avoid the synthetic keys ?

Re: How many ways to avoid the synthetic keys ?

Mon, 02 Sep 2013 18:35:21 GMT

Countless! Depends on the problem, but there's no only one, two or three ways.

Re: How many ways to avoid the synthetic keys ?

rbecher — Mon, 02 Sep 2013 18:52:23 GMT

Hi Naveen,

the most common ways IMHO are:

- building compound key fields (concat the values with a delimiter: field1 & '_' & field2)

- use link tables with distinct occurances of the field combination and use autonumber as surrogate key

- join the two tables to one resulting table

- Ralf

Re: How many ways to avoid the synthetic keys ?

Clever_Anjos — Mon, 02 Sep 2013 19:04:57 GMT

Ralf Becher covered 99% of the situation

Re: How many ways to avoid the synthetic keys ?

MayilVahanan — Mon, 02 Sep 2013 20:20:03 GMT

With addition of Ralf Becher ,

You can also rename the fieldname to avoid synthetic key

Re: How many ways to avoid the synthetic keys ?

v_iyyappan — Mon, 02 Sep 2013 20:23:02 GMT

Hi,

To remove the Synthetic Key to use following method,

1. When any two tables share more than one common field, QlikView creates a complex key, or synthetic key, to try and associate both tables through the combination of all of the common fields between them.

2. This takes the form of an additional table containing the shared fields and an additional key field added to all involved tables.

3. Suppose tables all filednames same means use the concatenate function to remove the Synthetic Key

Regards,