topic Re: Autnumberhash128 doesn't work in QlikView

Autnumberhash128 doesn't work

Tue, 14 Jan 2014 10:57:49 GMT

Hello i have two tables i need to link

i already have the elements for each to consitute the common key, when i use autonumberhash128 to constitute the key the relation between the two tables is not established (subset ratio on first table =23% and the other is 77 % which means that the tables don't have common values in their keys) , when i use just a simple concatenation of the fields (field1&Field2&Field3) on the keys of both tables , the relation is established their are common values.

How do you explain this issue?

Thanks in advance for your answers

Re: Autnumberhash128 doesn't work

Clever_Anjos — Tue, 14 Jan 2014 11:01:48 GMT

Please post your code to check how you´re using the function

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:25:23 GMT

Are you using the AutonumberHash128 function for both tables on the same qvw ?

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:27:30 GMT

Yes I am using it on both tables

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:30:39 GMT

autonumberhash128(field1, field2, field3,field4) as key ( on both tables doesn't work)

if I use

field1&'|'& field2&'|'&field3&'|'&field4 as key (on both tables it works)

Re: Autnumberhash128 doesn't work

bruno_m_santos — Tue, 14 Jan 2014 14:34:23 GMT

I suggest autonumberhash128(field1&'|'& field2&'|'&field3&'|'&field4).

It 'll work for sure.

Bruno

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:39:24 GMT

both tables are loading in same qvw ?

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:41:25 GMT

the thing is one of the two keys in question is linked to multiple other tables, i need to link a new table to the already existing tables (Three tables using the same key, need to add the fourth one with the same key ), the three first tables keys are all calculated with autonumberhash128(), when i tried to add the fourth table to them, it didn't work

Re: Autnumberhash128 doesn't work

Tue, 14 Jan 2014 14:41:59 GMT

yes they are in the same qvw