Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Autnumberhash128 doesn't work

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

8 Replies
Employee
Employee

Re: Autnumberhash128 doesn't work

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

Not applicable

Re: Autnumberhash128 doesn't work

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

Not applicable

Re: Autnumberhash128 doesn't work

Yes I am using it on both tables

Not applicable

Re: Autnumberhash128 doesn't work

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)

bruno_m_santos
Contributor

Re: Autnumberhash128 doesn't work

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

It 'll work for sure.

Bruno

Not applicable

Re: Autnumberhash128 doesn't work

both tables are loading in same qvw ?

Not applicable

Re: Autnumberhash128 doesn't work

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 

Not applicable

Re: Autnumberhash128 doesn't work

yes they are in the same qvw

Community Browser