topic Re: Problem with synthetic keys in QlikView

Problem with synthetic keys

Anonymous — Tue, 12 May 2015 06:57:50 GMT

Hi ,

In my datamodel there are no synthetic keys ,when i am using the same datamodel as binary load on my final application i am getting synthetic keys .Whatt could be the reason .? suggestions are appreciated

Thanks

Re: Problem with synthetic keys

amit_saini — Tue, 12 May 2015 07:00:51 GMT

Hi,

Might me in your application where you are calling binary having fields similar in your data model.

Thanks,
AS

Re: Problem with synthetic keys

Gysbert_Wassenaar — Tue, 12 May 2015 07:01:40 GMT

Do you load any additional data, rename fields or create new teables in the script of your final application?

Re: Problem with synthetic keys

Anonymous — Tue, 12 May 2015 07:08:29 GMT

Yes !! i have added two inline tables ..which are different

Re: Problem with synthetic keys

Gysbert_Wassenaar — Tue, 12 May 2015 07:10:12 GMT

If your inline tables contain field names that are also present in another table you can get a synthetic key.

Re: Problem with synthetic keys

amit_saini — Tue, 12 May 2015 07:13:19 GMT

Field names of those inline table should not be same as in your datamodel , better to rename fields in either of them.

Thanks,
AS

Re: Problem with synthetic keys

Anonymous — Tue, 12 May 2015 07:18:02 GMT

Yes ! They are different

Re: Problem with synthetic keys

amit_saini — Tue, 12 May 2015 07:20:41 GMT

Please do CTR+T and share screenshot of your datamodel when you are doing binary load.

Thanks,

Re: Problem with synthetic keys

Anonymous — Tue, 12 May 2015 07:21:15 GMT

Earlier i got the same synthetic keys at datamodel and i had resolved at datmodel level and there are no synthetic keys in datamodel .But when i am using same datamodel with binary load i am getting same synthetic keys which i resolved at datamodel level

Re: Problem with synthetic keys

amit_saini — Tue, 12 May 2015 07:27:07 GMT

Here 3 fields are common between FCT_SALES and FCT_Promo table :

#_Hierarchy_Date

Store_Key

Dept_Key

You should have one key common and rename others based on requirement.

Thanks,

Re: Problem with synthetic keys

Gysbert_Wassenaar — Tue, 12 May 2015 07:28:21 GMT

The synthetic key comes from the application you binary load your data from. Make sure you're using the right version of that document, i.e. the version where you resolved the synthetic key.

Re: Problem with synthetic keys

Anonymous — Tue, 12 May 2015 07:32:15 GMT

Thanks Gysbert !! let me check it and let you know

Re: Problem with synthetic keys

Anonymous — Tue, 12 May 2015 07:35:43 GMT

Yes!!! but i had resoved these at datamodel level .But i am getting these synthetic keys in my application

Re: Problem with synthetic keys

amit_saini — Tue, 12 May 2015 07:39:58 GMT

This is not possible Dear , i think you are using wrong version . Please check as suggested by Gysbert.

Thanks
AS