https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195568#M119 Hello <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Is this syntax correct for 3 values:</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Yes, you can <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />Best regards <BR /> <BR /> shong Tue, 16 Dec 2008 03:24:35 GMT Anonymous 2008-12-16T03:24:35Z https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195565#M116 Hello, <BR />I would like to implement a decode function. <BR />e.g. <BR /> DECODE (al1.dcf_status, <BR /> 'PART RECEIVED', 'RECEIVED', <BR /> al1.dcf_status <BR /> ) <BR />when I define an expression like: <BR />row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS <BR />it does not work. <BR />Why? <BR />Any ideas?? <BR />Thanks <BR />Didier Sat, 16 Nov 2024 14:07:35 GMT https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195565#M116 Anonymous 2024-11-16T14:07:35Z https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195566#M117 Hello <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>row1.DCF_STATUS =="PART RECEIVED"?"RECEIVED":row1.DCF_STATUS</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />If the filed type is a String, change to the following expression: <BR />row1.DCF_STATUS.equals("PART RECEIVED")?"RECEIVED":row1.DCF_STATUS <BR />Best regards <BR /> <BR /> shong Fri, 12 Dec 2008 02:18:32 GMT https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195566#M117 Anonymous 2008-12-12T02:18:32Z https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195567#M118 Is this syntax correct for 3 values: <BR />row1.DCF_STATUS.equals("VERIFIED")?1 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span>row1.DCF_STATUS.equals("CLOSED")?1 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span>row1.DCF_STATUS.equals("RECEIVED")?1:0)) <BR />thanks <BR />Didier Fri, 12 Dec 2008 12:19:26 GMT https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195567#M118 Anonymous 2008-12-12T12:19:26Z https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195568#M119 Hello <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Is this syntax correct for 3 values:</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Yes, you can <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />Best regards <BR /> <BR /> shong Tue, 16 Dec 2008 03:24:35 GMT https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195568#M119 Anonymous 2008-12-16T03:24:35Z https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195569#M120 <P>Could you please​ tell me why we are using ( :row1.DCF_STATUS ) in last. </P> Thu, 16 Jun 2022 03:32:03 GMT https://community.qlik.com/t5/Talend-Studio/DECODE-function/m-p/2195569#M120 DSingh1654264730 2022-06-16T03:32:03Z