topic Re: Synthetic keys . How to remove them in QlikView

Synthetic keys . How to remove them

Wed, 07 May 2014 05:23:32 GMT

Synthetic keys . How to remove them

Re: Synthetic keys . How to remove them

senpradip007 — Wed, 07 May 2014 05:27:53 GMT

Remane the field name, synthetic keys would removed.

Tab1:

Load

A as Id,

From <Table Name>;

Load

A as Serial,

From <Table Name>;

Re: Synthetic keys . How to remove them

sujeetsingh — Wed, 07 May 2014 05:31:15 GMT

Renaming is the one way to remove the Synthetic keys but First go to this link

Should We Stop Worrying and Love the Synthetic Key?

Re: Synthetic keys . How to remove them

Wed, 07 May 2014 05:34:49 GMT

thank you sujeetsingh

Re: Synthetic keys . How to remove them

Wed, 07 May 2014 05:38:51 GMT

Either your represent the field name with a alias or you use Qualifier statement . In some case one could even comment or ignore the fields which are not required as per your requiremnet

Thanking You

Vinayagam

Re: Re: Synthetic keys . How to remove them

Wed, 07 May 2014 05:48:07 GMT

hi please go through this

Re: Synthetic keys . How to remove them

hic — Wed, 07 May 2014 09:30:01 GMT

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

The following can also be useful, although it is not directly about synthetic keys:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

HIC

Re: Synthetic keys . How to remove them

Wed, 07 May 2014 16:30:45 GMT

thankyou

Re: Synthetic keys . How to remove them

its_anandrjs — Wed, 07 May 2014 18:03:00 GMT

I believe you get all information related to the synthetic keys and how to avoid them or you can refer the attached document.

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

Re: Synthetic keys . How to remove them

Joseph_Musekura — Wed, 07 May 2014 18:20:43 GMT

Hi,

Here are three ways to get rid of Synthetic Keys

1. Using QUALIFY

This enforces QlikView to qualify all/selected fields. Qualify implements the check on full path of the field (e.g. Field is designated by Tablename.FieldName).

2. Autonumber

If you need to concat the Syn Key candidate fields and create your own key, you can use Autonumber/Autonumberhash128/Autonumberhash256 function. This will create a unique integer value for each distinct combination of the concateneted columns.

Autonumberhash128 and Autonumberhash256 creates 128bit and 256bit values respectively.

One word of cauton using Autonumber is, as they are system generated, you do not have any control over the values. And for external QVDs, since the range of unique autonumber values are limited, uniqueness is not guranted. the hash128 and hash256 functions particularly address this issue and widens the range to ensure uniqueness.

3. Aliasing

If you alias the comflicting fields, i.e. the Syn Key candidate fields, they would be treated as different fields and will not be joined automatically by QV. This is a simple solution based on how flexible the requirements are, in renaming the fields.

Ofcourse you will find many other examples in this forum/QV manual that will strenthen your concept. This is my understanding from my experience with QV. Please let me know if it answers your question on my post.

You can read more from

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

/joseph

Re: Synthetic keys . How to remove them

Thu, 08 May 2014 07:44:00 GMT

thankyou