question

[#1]

what is difference between autonumberhash and rowno()

[amit_saini]

Ramya,

check this:

rowno() and recno()

Thanks,

AS

[ashfaq_haseeb]

Check this too

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

autonumberhash?

Regards

ASHFAQ

[alexandros17]

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

[jagan · Accepted solution]

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.

[sujeetsingh]

jAGAN GIVEN THEM IN BEST WAY