https://community.qlik.com/t5/Talend-Studio/I-try-to-convert-guid-to-an-integer-for-a-new-database/m-p/2281974#M56330 Hello, <BR />For my migration of two CRM i need to convert many GUID into integer id ... <BR />How can I do that with a tmap ?<BR />Thank you i'm looking for a while ! Tue, 25 Feb 2014 14:04:26 GMT Anonymous 2014-02-25T14:04:26Z https://community.qlik.com/t5/Talend-Studio/I-try-to-convert-guid-to-an-integer-for-a-new-database/m-p/2281974#M56330 Hello, <BR />For my migration of two CRM i need to convert many GUID into integer id ... <BR />How can I do that with a tmap ?<BR />Thank you i'm looking for a while ! Tue, 25 Feb 2014 14:04:26 GMT https://community.qlik.com/t5/Talend-Studio/I-try-to-convert-guid-to-an-integer-for-a-new-database/m-p/2281974#M56330 Anonymous 2014-02-25T14:04:26Z https://community.qlik.com/t5/Talend-Studio/I-try-to-convert-guid-to-an-integer-for-a-new-database/m-p/2281975#M56331 It depends what you want. You could use the hashCode() method to build an integer from the String guid. <BR />use as expression <BR />row1.GUID.hashCode() <BR />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. Tue, 25 Feb 2014 22:01:06 GMT https://community.qlik.com/t5/Talend-Studio/I-try-to-convert-guid-to-an-integer-for-a-new-database/m-p/2281975#M56331 Anonymous 2014-02-25T22:01:06Z