https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322919#M92821 Hi, <BR />In tMap, I am mapping one date field to two different output tables. In one table it is expecting a date, in another table it is expecting an integer. So, I need to convert a date field into integer for the second table. <BR />How do I do that? <BR />Thanks, <BR />Boris Sat, 16 Nov 2024 13:35:06 GMT Anonymous 2024-11-16T13:35:06Z https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322919#M92821 Hi, <BR />In tMap, I am mapping one date field to two different output tables. In one table it is expecting a date, in another table it is expecting an integer. So, I need to convert a date field into integer for the second table. <BR />How do I do that? <BR />Thanks, <BR />Boris Sat, 16 Nov 2024 13:35:06 GMT https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322919#M92821 Anonymous 2024-11-16T13:35:06Z https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322920#M92822 I was able to find a workaround for this, however, now I need to convert a String to BigDecimal and I am not able to do that.<BR />What is the best way? Fri, 29 Jan 2010 20:15:12 GMT https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322920#M92822 Anonymous 2010-01-29T20:15:12Z https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322921#M92823 Does anyone have a solution for me on converting String to BigDecimal? <BR />Oracle expects a NUMBER in this column. And I have it as String in tMap. <BR />I am mapping this same field to another column in another table as: TalendDate.parseDate("MM/dd/yyyy",row1.newColumn9) Fri, 29 Jan 2010 21:14:16 GMT https://community.qlik.com/t5/Talend-Studio/Convert-date-to-integer/m-p/2322921#M92823 Anonymous 2010-01-29T21:14:16Z