How to convert/map a string key to a unique number key?

[Anonymous]

Dear All,

Is there anyway to convert/map a string key to a unique number key?

This unique number should not change in any condition, such as belong to number of records when loading.

Thank you.

[Anonymous]

I need convert to number for performance

[Anonymous]

If there is anyway or function to map from one group of string to one exactly and unique number?

If there is one, I think this problem would be fixed.

[marcus_sommer]

AFAIK there don't exists such a function in Qlik but it's (in general) possible to build such a functionality whereby like above mentioned it depends on how the keys look like. If are the key-parts numbers there is a real chance to get it to work - if the key-parts are strings (which really couldn't be replaced by an ID) it's rather unlikely especially because Qlik treated only values until 14-digits as number (in special cases also 15-digits) but after that it's also a string.

Therefore how does the keys look like?

- Marcus

[Anil_Babu_Samineni]

Then, May be this?

Load * From Table2 ;

Load * From Table1 Where Not Exists(uniquenumber_1, uniquenumber_2);

[acardella]

just remeber...

AutonumberHash only works into same reload app, not across applications, because it depends also from data load order.

As Maria said (@JaMajka1), you can use Hash() but result is in string format, not a scalar

https://community.qlik.com/t5/QlikView-App-Dev/use-of-hash-function/m-p/1385736#M805773