autonumberhash128 in qlikview

[Anonymous]

Hi All,

Please explain autonumberhash128 in qlikview .I have gone through qv help but i didn't get clarity on it .please expalin it with a  sample

Thanks

[deepakqlikview_123]

use for creation of compact memory representation of complex key.

Moreover we can aslo generate numbers using this.

Eg for creation of link table we can use it.

[alexandros17]

Try this example:

AAA:
LOAD * Inline [
name, surname, country, age
Alex, Saxon, Italy, 34
Tom, Sawer, UK, 25
Anne, Lorraine, France, 31
];

BBB:
NoConcatenate
LOAD name, surname, country, age, AutoNumberHash128(name, surname) as key Resident AAA;
DROP Table AAA;

You will see a numerical representation of fields name and surname togheter.

[jagan]

Hi,

You can generate unique key based on the given values in script. For example

Data:

LOAD

AutoNumberHash128(name, surname) as key,

name, surname, country, age,

FROM Datasource;'

You can also create key by concatenating the columns like below

name &'_'& surname as key

but this will take more memory to save.

Regards,

Jagan.

[its_anandrjs]

Hi,

AutonumberHash128 is used to increase the performance and while using Autonumberhash128 it creating a compact memory representation for the given text fields and other fields.

Ex:-

autonumberhash128(expression {, expression})

autonumberhash128 ( Region, Year, Month )

Regards,

Anand