how map range of values ?

I have 48794 unique values, i need 16 bit to represent it as binary code. where 2^16=65536.

but the problem that these 48794 valuse are not numbered from 1 to 48794.

my values are given id's between 1 and 66726. i.e max value be 66726 , in this case I have to use 17 bit to represent them uniquely.

how i can map my values to be from 1 to 48794?

thanks in advance

Answer 1

[Walter Roberson]

unique() the list of IDs. The mapped ID is then the index of the ID in the unique array. There are performance optimizations that can be made if the lookups happen frequently enough to justify the memory.

[huda nawaf]

thanks walter