Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I try to convert guid to an integer for a new database

Hello,
For my migration of two CRM i need to convert many GUID into integer id ...
How can I do that with a tmap ?
Thank you i'm looking for a while !
Labels (2)
1 Reply
Anonymous
Not applicable
Author

It depends what you want. You could use the hashCode() method to build an integer from the String guid.
use as expression
row1.GUID.hashCode()
But please keep in mind an hashCode is not fully unique. If your GUID string has always nearly the same length it is very likely unique but if the guid has wide spread length, this will not work for a huge number of values.