topic Re: Dynamic field in script load to count unique strings in QlikView

Dynamic field in script load to count unique strings

Tue, 12 Nov 2013 19:01:30 GMT

Hi all,

I would like to create a field in my script load that counts unique vendor names. For instance, if I have 1000 line items in my source file divided between 3 vendors - Widgets Co, XYZ Supplier, and FakeVendor - I would like to give each of them a unique number (1,2,3):

Widgets Co. - 1

XYZ Supplier - 2

FakeVendor - 3

That way, as I add vendors to my source file, I can access them dynamically in the QV application by referencing the unique numbers in set analysis. How do I do this?

Thanks.

Re: Dynamic field in script load to count unique strings

Anonymous — Tue, 12 Nov 2013 19:09:47 GMT

Paul

Sounds like you are after the autonumberhash128() function.

Try it in your load script as something like:

autonumberhash128( [VendorField] ) as [Vendor Key]

Best Regards, Bill

Re: Dynamic field in script load to count unique strings

Tue, 12 Nov 2013 19:20:29 GMT

Wow, what an incredibly helpful function! I had no idea this was built-in. Out of curiosity, what does AutoNumberHash256() do?

Re: Dynamic field in script load to count unique strings

Anonymous — Tue, 12 Nov 2013 19:30:11 GMT

Paul

The Qlikview Desktop Help gives quite a good description of AutoNumberHash256().

Best Regards, Bill