https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332439#M101322 Hello <BR />Try <BR /> <PRE>row1.columnName.equals("")?null:row1.columnName</PRE> <BR />Best regards <BR />Shong Tue, 30 Mar 2010 03:39:26 GMT Anonymous 2010-03-30T03:39:26Z https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332438#M101321 On an output data stream I can't figure out how to have the output column be transformed to NULL or even empty string for a particular column. <BR />The output column metadata is varchar(2) <BR />I have tried all kinds of useless things: <BR />Char(0) <BR />''.tostring() <BR />Null <BR />NULL <BR />etc etc <BR />Variables etc. <BR />Most of the time i get 'Invalid Operand Types String and Char') <BR />This seems so simple- how am I being stupid? <BR />Thanks. Marc Sat, 16 Nov 2024 13:29:17 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332438#M101321 Anonymous 2024-11-16T13:29:17Z https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332439#M101322 Hello <BR />Try <BR /> <PRE>row1.columnName.equals("")?null:row1.columnName</PRE> <BR />Best regards <BR />Shong Tue, 30 Mar 2010 03:39:26 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332439#M101322 Anonymous 2010-03-30T03:39:26Z https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332440#M101323 this worked thank you. Mon, 19 Apr 2010 02:46:49 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Insert-Null-into-Expression-for-Column-in-tMap/m-p/2332440#M101323 Anonymous 2010-04-19T02:46:49Z