topic Re: Synthetic Keys required? in QlikView

Synthetic Keys required?

Anonymous — Thu, 16 Apr 2015 14:37:39 GMT

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!

Re: Synthetic Keys required?

MK_QSL — Thu, 16 Apr 2015 14:39:44 GMT

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 .....

Re: Synthetic Keys required?

Anonymous — Thu, 16 Apr 2015 14:48:23 GMT

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?

Re: Synthetic Keys required?

MK_QSL — Thu, 16 Apr 2015 14:50:29 GMT

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

Re: Synthetic Keys required?

Anonymous — Thu, 16 Apr 2015 15:07:42 GMT

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

Thanks!

Re: Synthetic Keys required?

MK_QSL — Thu, 16 Apr 2015 15:30:25 GMT

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