About synthetic Keys??

[#1]

Hi Qlikies,

Please refer the following images

Image1 is the TableViewer(TV) with synthetic keys and Image2 is the TV without Synthetic keys.

What I did is...I just renamed few fields in the table....is that approach correct to remove synthetic keys??

If so If i rename the fields the link between fields wont get disturb aa aa???

And please tell me where to remove synthetic keys??? and where not to remove Synthetic keys??

Please dont give me any links to refer...I just want a clear simple explanation...!!

Thank you so much in Advance

eagerly waiting for your replies....!!

[Anonymous]

Simple, Yes, that looks good!

Renaming is usually all it takes to remove unexpected synthetic keys. QlikView links fields based on the field names so unexpected links can occur compared to a relational database with key fields defined as key fields etc.

[#3]

Thank you..!!

But is it mandatory to remove Synthetic keys???

[jagan]

Hi,

Check this link

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

Hope it helps you.

Regards,

Jagan.