Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MH_Newbie
Contributor II
Contributor II

Problem with synthetic keys

Hey!

I'm quite new to QlikView and trying to improve my data modeling skills.
My current problem is that synthetic keys are created where I don't want  to have them and I don't have any solution at the moment.

Following pic will show you my structure:

clipboard_image_0.png

My former key %Position_Artikel turned into a synthetic key by adding the new table 'Nebenlager'. I tried to associate it to 'Artikel' which didn't work. Both tables have similar fields called 'ArtikelNr' (Nebenlager) or 'ArtikelPart_Nr' (Artikel).

Is there any solution how I can associate those two tables without touching 'Positionen'?

Thanks!

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

Just renaming one Artikel field like: ArtikelNr as ArtikelNr_XYZ would remove the synthetic key. It depends on the content of your article-fields and their context if this will work or if you need to rename one or more of them into ...position or reversed or maybe combining both fields within a single field.

- Marcus

View solution in original post

4 Replies
marcus_sommer

Just renaming one Artikel field like: ArtikelNr as ArtikelNr_XYZ would remove the synthetic key. It depends on the content of your article-fields and their context if this will work or if you need to rename one or more of them into ...position or reversed or maybe combining both fields within a single field.

- Marcus

wade12
Partner - Creator II
Partner - Creator II

generally there are 3 options to fix/solve a synthetic key issue:
1. do not load fields causing synthetic key (except for one ... in order to preserve the association)
2. rename fields causing synthetic key (except for one ... in order to preserve the association)
3. create a link table.
MH_Newbie
Contributor II
Contributor II
Author

Thank you, it worked out well!

No more synthetic keys 🙂

Brett_Bleess
Former Employee
Former Employee

Magdalena, here is a Design Blog link that should potentially help in addition to Marcus' post, there are a bunch of other topics in this area of Community as well, so you may want to use it in the future when you are trying to figure out how to do some things.  Glad Marcus was able to get you fixed up this time.

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.