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: 
Anonymous
Not applicable

Synthetic Keys required?

Hi All,

I still consider myself new to Qlikview.  I'm the only one at the company who is designing, developing, and administering anything.  I also have an accounting background, so some of this stuff is still lost on me, but I'm learning and having a blast.

We're working with Dynamics GP2013.  I've noticed that sometimes my data seems to break when I DON'T have a synthetic key.  It seems that the data that makes the most sense to join on is only partial in one table.  In an Accounts Receivable app I'm building, the data doesn't seem to work if I don't join on both Customer Number AND Document Number.

Is this normal, or is there something that I am missing? 

Also - if anyone knows of any Qlikview Dynamics GP groups, please point them out to me. 

Thanks!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

In that case create a composite key

[Customer Number] & '|' & [Document Number] as JoinKey

to join your respective tables..

So you both tables looks like below

Table1:

[Customer Number] & '|' & [Document Number] as JoinKey,

[Customer Number],

[Document Number]

From .....



Table2:

[Customer Number] & '|' & [Document Number] as JoinKey,

//[Customer Number],

//[Document Number]

From .....

View solution in original post

5 Replies
MK_QSL
MVP
MVP

In that case create a composite key

[Customer Number] & '|' & [Document Number] as JoinKey

to join your respective tables..

So you both tables looks like below

Table1:

[Customer Number] & '|' & [Document Number] as JoinKey,

[Customer Number],

[Document Number]

From .....



Table2:

[Customer Number] & '|' & [Document Number] as JoinKey,

//[Customer Number],

//[Document Number]

From .....

Anonymous
Not applicable
Author

Manish,

Thanks for the help and the detailed answer. 

Does this have any effect on anything other than eliminating the Synthetic Key?

Wouldn't you comment out the Customer Number and the Document Number from one of each table?  Won't that continue to create a synthetic key?

MK_QSL
MVP
MVP

If you remove Customer Number and Document Number from one of the table, this will not create a Synthetic Key and the tables would be joined by JoinKey.... Also, both the removed fields are available to both table through the JoinKey

Anonymous
Not applicable
Author

Ah - I didn't see that you commented out the field. 

Thanks!

MK_QSL
MVP
MVP

If you get your reply, please close the thread...