topic Re: Generate Numbers from a Field in QlikView

Generate Numbers from a Field

microwin88x — Tue, 10 Feb 2015 19:31:53 GMT

Hello,

I have the following table in script:

What I need is to generate a new field ID with a unique number for the BINARY field like this:

I could have repeated numbers in BINARY, so the generated number in ID should considerate this possibility.

Do you know if there's any way to do this?

Thank you!

german_avanzato — Tue, 10 Feb 2015 19:40:31 GMT

You should use the command

AutoNumber in the script:

AutoNumber( BINARY) as ID

JonnyPoole — Tue, 10 Feb 2015 19:42:47 GMT

You could use autonumber() for this

EX:

LOAD ACCT_ID,

BINARY,

AutoNumber(BINARY) as Key

FROM

(html, codepage is 1252, embedded labels, table is @1);

Result: