Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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