topic Re: Synthetic Keys in QlikView and how & when to avoid them? in QlikView

Synthetic Keys in QlikView and how & when to avoid them?

Fri, 20 Nov 2020 18:02:30 GMT

With practical example.

Thanks&Regards

Ramesh

Re: Synthetic Keys in QlikView and how & when to avoid them?

Sun, 20 Jul 2014 07:26:41 GMT

Hi,

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys

See this i think it ll be helpful for u to understand about synthetic keys.

Re: Synthetic Keys in QlikView and how & when to avoid them?

Sun, 20 Jul 2014 08:41:20 GMT

Hi,

Check this out and find the attached qvw file

1. Script with Syn Key

LOAD CustId,

Name,

Address,

Contact

FROM

(ooxml, embedded labels, table is Cust);

LOAD DepID,

Name,

Address,

CustId

FROM

(ooxml, embedded labels, table is Dep);

2. Script with out syn Key

scenario 1:

LOAD CustId,

Name,

Address,

Contact

FROM

(ooxml, embedded labels, table is Cust);

LOAD DepID,

Name as Dep_Name,

Address as Dep_Address,

CustId

FROM

(ooxml, embedded labels, table is Dep);

scenario 2:

QUALIFY *;

UNQUALIFY CustId;

UNQUALIFY DepID;

LOAD CustId,

Name,

Address,

Contact

FROM

(ooxml, embedded labels, table is Cust);

LOAD DepID,

Name,

Address,

CustId

FROM

(ooxml, embedded labels, table is Dep);

Re: Synthetic Keys in QlikView and how & when to avoid them?

MarcoWedel — Sun, 20 Jul 2014 10:35:44 GMT

Another interesting post by John Witherspoon (http://community.qlik.com/people/JohnW)

http://community.qlik.com/message/10279#10279

regards

Marco

Re: Synthetic Keys in QlikView and how & when to avoid them?

Mon, 21 Jul 2014 05:25:56 GMT

Synthetic keys are nothing but some common fields between tables.It should be avoided at the time of Data Modelling because tables should be combined by a Primary key which is more convenient.To avoid we can alias the common fields by using Qualify or doing it manually.

Thanks

Re: Synthetic Keys in QlikView and how & when to avoid them?

vardhancse — Mon, 21 Jul 2014 05:29:21 GMT

if there are more than 1 common fields in tables, then those fields will be called as synthetic keys.

These can be rectified in many ways:

1. Rename of the fields

2. removing same fields which are not required(Remove duplicate fields)

Re: Synthetic Keys in QlikView and how & when to avoid them?

siva_boggarapu — Mon, 21 Jul 2014 07:52:30 GMT

Hi,

we can remove Synthetic keys by using

Qulify and Unqulify statements.

For more help Press "F1" in Qlikview tool.

Thanks,

Siva