Dynamic field in script load to count unique strings

[#1]

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.

[Anonymous · Accepted solution]

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

[#3]

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

[Anonymous]

Paul

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

Best Regards,     Bill