Synthetic Keys required?

[Anonymous]

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!

[MK_QSL · Accepted solution]

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]

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]

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]

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

Thanks!

[MK_QSL]

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