composite key?

[Anonymous]

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?

[Anonymous]

Comment them out.

[jvitantonio]

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.

JV

[Anonymous]

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

[#5 · Accepted solution]

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