topic Re: question in QlikView

question

Thu, 20 Nov 2014 07:49:31 GMT

what is difference between autonumberhash and rowno()

Re: question

amit_saini — Thu, 20 Nov 2014 07:54:18 GMT

Ramya,

check this:

rowno() and recno()

Thanks,

Re: question

ashfaq_haseeb — Thu, 20 Nov 2014 07:55:13 GMT

Check this too

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

autonumberhash?

Regards

ASHFAQ

Re: question

alexandros17 — Thu, 20 Nov 2014 07:56:50 GMT

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

Re: question

jagan — Thu, 20 Nov 2014 08:15:52 GMT

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.

Re: question

sujeetsingh — Thu, 20 Nov 2014 08:27:35 GMT

jAGAN GIVEN THEM IN BEST WAY