Avoid a synthetic keys with Alias? is it possible?

[Anonymous]

Hi Experts!!

In relationship with "What is synthetic keys? How it can be avoided? "

someone answer  1) use Qualify

                           2) use Alias

of course if we use a Qualify* we are avoiding the synthetic key because every  column have the prefix of the table name.

so it is a nice way to avoid it.

But as much as I know, "alias" it is used to reanme fields but for all the tables so it doesnt really help because with a diferente name we still have the same  problem. am I  missing something?

Its possible to avoid a synthetic key with a Alias? and if its possible  how?

Thanks in Advance , Enrique

[MK_QSL]

Check this..

How to Rename Fields

[krishnacbe · Accepted solution]

Hi,

Alias is nothing but renaming the fields. The common fields except the key column should be renamed to avoid synthetic key.

You can do it two ways.

1. In Load statement Column1 as New_Column1

2. Using the Rename Statement. ex. Rename Field Column1 to New_Column1

[Anonymous]

That's what i thought, but i still wanted to know if were something hide , that i missed.

Thanks for answer.

[surendraj]

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/

refer the above links for your reference.you can remove synthatic keys by

Aliasing

concatinating

link table

qualify and unqualify.