https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243251#M29807 Hi,<BR />I think you can use this :<BR />Double.parseDouble(row1.id).intValue()<BR /><BR />Regards,<BR />Lie Mon, 28 Jun 2010 16:04:37 GMT Anonymous 2010-06-28T16:04:37Z https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243250#M29806 my source is a flat file ,data has value which may or maynot be a decimal (eg.12345.89 or 3456),we want only the integer part of it and not the decimal part of it(eg 12345 and not 12345.89) <BR />I am creating a variable , <BR />StringHandling.INDEX(row1.id,".") == -1 ? StringHandling.LEN(row1.id) : StringHandling.INDEX(row1.id,".") <BR />and another variable , <BR />Integer.parseInt(StringHandling.LEFT(row1.id,Var.index)) <BR />It is working fine and i am getting the required output,but i still want to know if there is any other better way for resolving this requirement <BR />Thanks in advance, <BR />Amk Sat, 16 Nov 2024 13:22:31 GMT https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243250#M29806 Anonymous 2024-11-16T13:22:31Z https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243251#M29807 Hi,<BR />I think you can use this :<BR />Double.parseDouble(row1.id).intValue()<BR /><BR />Regards,<BR />Lie Mon, 28 Jun 2010 16:04:37 GMT https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243251#M29807 Anonymous 2010-06-28T16:04:37Z https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243252#M29808 Thank you Lie,I will try and get back to you...<BR />Regards,<BR />Amk Mon, 28 Jun 2010 16:06:48 GMT https://community.qlik.com/t5/Talend-Studio/Convert-from-double-to-integer/m-p/2243252#M29808 Anonymous 2010-06-28T16:06:48Z