topic Convert short and long numbers to Integers? in Talend Studio https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344322#M111990 I have an access database and am moving data to a postgresql DB. Many of the fields in the access are listed as short or long. How do I convert to the Integer type in Postgresql? <BR />Any suggestions are welcome. <BR />Thanks. Sat, 16 Nov 2024 13:28:21 GMT Anonymous 2024-11-16T13:28:21Z Convert short and long numbers to Integers? https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344322#M111990 I have an access database and am moving data to a postgresql DB. Many of the fields in the access are listed as short or long. How do I convert to the Integer type in Postgresql? <BR />Any suggestions are welcome. <BR />Thanks. Sat, 16 Nov 2024 13:28:21 GMT https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344322#M111990 Anonymous 2024-11-16T13:28:21Z Re: Convert short and long numbers to Integers? https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344323#M111991 Hello <BR />You can convert short/long to int/integer on tMap, for example: <BR />on the expression of output column, type in <PRE>(int)row1.columnName</PRE> <BR />Best regards <BR />Shong Wed, 07 Apr 2010 04:39:06 GMT https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344323#M111991 Anonymous 2010-04-07T04:39:06Z Re: Convert short and long numbers to Integers? https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344324#M111992 Shong!! <BR />When i want to convert form long to int in tmap..but it throws me an error..saying it cant cast from long to int Wed, 25 May 2011 11:57:58 GMT https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344324#M111992 Anonymous 2011-05-25T11:57:58Z Re: Convert short and long numbers to Integers? https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344325#M111993 <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Shong!!<BR />When i want to convert form long to int in tmap..but it throws me an error..saying it cant cast from long to int</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />ah, the error message should be 'it can't cast from Long to int'!, this is because Long is an object, to get around it, uncheck the 'nullable' box on schema. <BR />Best regards <BR />Shong Fri, 27 May 2011 03:37:05 GMT https://community.qlik.com/t5/Talend-Studio/Convert-short-and-long-numbers-to-Integers/m-p/2344325#M111993 Anonymous 2011-05-27T03:37:05Z