https://community.qlik.com/t5/Talend-Studio/convert-string-datatype-to-boolean-datatype/m-p/2269245#M47559 Hello, <BR />I have requirement where i have to convert a string coming from a database to a boolean datatype in to salesforce. <BR />the &nbsp;string value are ( 'Y' and 'N' ) from a column in table..... <BR />and my mapping components are&nbsp; <BR />sql server table---&gt;tmap--&gt;salesforce output component... <BR />which method should i use in tmap expression editor to convert the string 'N' or string 'Y' to boolean datatype for salesforce. <BR />or this needs to be converted by using something else???im new to talend so pls provde the answer in detail Sat, 16 Nov 2024 11:21:58 GMT Anonymous 2024-11-16T11:21:58Z https://community.qlik.com/t5/Talend-Studio/convert-string-datatype-to-boolean-datatype/m-p/2269245#M47559 Hello, <BR />I have requirement where i have to convert a string coming from a database to a boolean datatype in to salesforce. <BR />the &nbsp;string value are ( 'Y' and 'N' ) from a column in table..... <BR />and my mapping components are&nbsp; <BR />sql server table---&gt;tmap--&gt;salesforce output component... <BR />which method should i use in tmap expression editor to convert the string 'N' or string 'Y' to boolean datatype for salesforce. <BR />or this needs to be converted by using something else???im new to talend so pls provde the answer in detail Sat, 16 Nov 2024 11:21:58 GMT https://community.qlik.com/t5/Talend-Studio/convert-string-datatype-to-boolean-datatype/m-p/2269245#M47559 Anonymous 2024-11-16T11:21:58Z https://community.qlik.com/t5/Talend-Studio/convert-string-datatype-to-boolean-datatype/m-p/2269246#M47560 Hi Ather,<BR />you can write like this in tMap<BR />databasevalue.equals("Y")?true:false. please try this once<BR />Thanks<BR />Srikanth&nbsp; Thu, 08 Jan 2015 04:23:19 GMT https://community.qlik.com/t5/Talend-Studio/convert-string-datatype-to-boolean-datatype/m-p/2269246#M47560 Anonymous 2015-01-08T04:23:19Z