topic Re: composite key? in QlikView

composite key?

Anonymous — Tue, 13 Jan 2015 13:46:47 GMT

Hi all,

i have a 2 common fields between 2 tables when i reloaded i got synthetic key

to remove synthetic key i used like

autonumberhash128(field1,filed2) as newkey

this statment i have written in 2 tables to remove synthetic key

here my question is after writing this statment do i need to comment those 2 common fields in any one table or not?

because when i go in this way like

field1 &'_"& field2 as newkey (written same line in another table also) ,we use to comment fiedls in any one table.

if we use autonumber means is it required to comment or not required?

if i did not comment whether data will come properly?

Re: composite key?

Anonymous — Tue, 13 Jan 2015 13:52:06 GMT

Comment them out.

Re: composite key?

jvitantonio — Tue, 13 Jan 2015 13:52:07 GMT

Hi,

That's correct. You either remove those fields (comment them out) or you rename them so they all have different names. This will prevent qlikview from creating synthetic keys.

Re: composite key?

Anonymous — Tue, 13 Jan 2015 14:22:52 GMT

but in my script it self

early they have created a composite key using autonumberhash128.

they have written same line in both tables ,

not at all commented fields in any table.

got result why?

is it possible

Re: composite key?

Tue, 13 Jan 2015 14:27:48 GMT

then they might have rename that field so that it may not get connect with the other table which will for synthetic keys.