Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is difference between autonumberhash and rowno()
Hi,
autonumberhash() - will encrypt the given value
rowno() - returns the current row number in Load statement.
Example:
LOAD
AutoNumberHash(Country) AS Key, -- Hashes / Encrypts the string
RowNo() as CountryID, 1 for India, 2 for USA
Country,
Sales
INLINE [
Country, Sales
India, 1000
USA, 800 ];
Hope this helps you.
Regards,
Jagan.
Check this too
http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno
Regards
ASHFAQ
The first rcomputer a string (hash) resulting from expression or fields and return an integer, can be used to compress complex key into one value, the second
returns an ibteger for the position of current row in internal table
Hi,
autonumberhash() - will encrypt the given value
rowno() - returns the current row number in Load statement.
Example:
LOAD
AutoNumberHash(Country) AS Key, -- Hashes / Encrypts the string
RowNo() as CountryID, 1 for India, 2 for USA
Country,
Sales
INLINE [
Country, Sales
India, 1000
USA, 800 ];
Hope this helps you.
Regards,
Jagan.
jAGAN GIVEN THEM IN BEST WAY