topic Update value in join in QlikView https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241710#M92103 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>If there is a link between the two tables then we might able to update it on Qlikview.</P><P></P><P></P></BODY></HTML> Tue, 08 Mar 2011 12:08:12 GMT deepakk 2011-03-08T12:08:12Z Update value in join https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241709#M92102 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I really do hope if one of you knows the solution to this problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I am importing Users (from xls file) table that contains the following fields:</P><P>email, firstname, lastname, optin</P><P>In second xls file I have list of unsubscribers. is there any way to update optin field based on the content of unsubscribers table?</P><P>Hope it makes sense!</P><P>Regards, M</P><P></P></BODY></HTML> Tue, 08 Mar 2011 11:56:55 GMT https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241709#M92102 2011-03-08T11:56:55Z Update value in join https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241710#M92103 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>If there is a link between the two tables then we might able to update it on Qlikview.</P><P></P><P></P></BODY></HTML> Tue, 08 Mar 2011 12:08:12 GMT https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241710#M92103 deepakk 2011-03-08T12:08:12Z Update value in join https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241711#M92104 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can load yours tables User and Unsubscribers and join their on email to add a new field with the new value for the optin field.</P><P>You must create a new field Optin for exemple Optin_tmp and after drop field optin and rename your Optin_tmp in optin.</P></BODY></HTML> Tue, 08 Mar 2011 12:08:57 GMT https://community.qlik.com/t5/QlikView/Update-value-in-join/m-p/241711#M92104 pljsoftware 2011-03-08T12:08:57Z