topic replace a value in column in QlikView https://community.qlik.com/t5/QlikView/replace-a-value-in-column/m-p/695136#M674079 <HTML><HEAD></HEAD><BODY><P>How to replace a value in a column if the value of a&nbsp; field in one table does not exist in another table?</P></BODY></HTML> Fri, 01 Aug 2014 06:34:27 GMT 2014-08-01T06:34:27Z replace a value in column https://community.qlik.com/t5/QlikView/replace-a-value-in-column/m-p/695136#M674079 <HTML><HEAD></HEAD><BODY><P>How to replace a value in a column if the value of a&nbsp; field in one table does not exist in another table?</P></BODY></HTML> Fri, 01 Aug 2014 06:34:27 GMT https://community.qlik.com/t5/QlikView/replace-a-value-in-column/m-p/695136#M674079 2014-08-01T06:34:27Z Re: replace a value in column https://community.qlik.com/t5/QlikView/replace-a-value-in-column/m-p/695137#M674080 <HTML><HEAD></HEAD><BODY><P>ApplyMap&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //if you are trying to replace in the table where values exist</P><P>Join and then replace (May be with an IF)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //if you are trying to replace in the table where values <STRONG>don't</STRONG> exist</P></BODY></HTML> Fri, 01 Aug 2014 06:36:29 GMT https://community.qlik.com/t5/QlikView/replace-a-value-in-column/m-p/695137#M674080 tresB 2014-08-01T06:36:29Z