Synthetickeys issue

[#1]

Hi all,

I am loading the entire tables from my SQL server into Qlikview. When i reloaded all the tables in qlikview then it is generating an synthetic keys.

Please find the attached screenshot of table viewer.

Whether this table viewer structure with synthetic key creates any problem at any case in the application ? And if it creates problem then how we can resolve this issue ?

Thanks in advance.

[pgalvezt]

Hi, Prid Field just has one value?

[#3]

Hi,

Yes PRID has only one value currently because data got loaded from single excel file.

If we load data from multiple excel files then the PRID will have that number of values. i.e; Each excel has one PRID value.

Thanks in advance.

Regards,

Venkat

[pgalvezt]

Ok, see the attached please.

Hope Help you.

[pgalvezt]

If you want you can change the name Prid for all tables. But you are going to have a synthetics keys again. But check the information with that, maybe works even with SK.

Hope Help You

[pgalvezt]

Hi,

Could you solve the problem?

[#7]

Hi Pgalvezt,

Really thanks for your co-ordination on this post from last few days.

But i'm really confused a lot to maintain perfect relation without synthetic keys in current data.

I will attach the final and original data application to you in another few minutes.

And i'm sorry to disturb you on this more times. But i hope you can understand my problem and supporting on this.

Thanks in advance.

[#8]

Hi,

The attached app resolves my issue.

Just i had done little changes in my app by comparing previously attached app by you.

I think this application is looking good so for now and i will get back you if any help requires on this.

Really thanks for your wonderful support on this to me.

Thanks & Regards,

Venkat.

[pgalvezt]

Please put the Correct Answer so the other people can understand the problem and the solution.