topic Re: Re-writing data from other source in QlikView https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036508#M642374 <HTML><HEAD></HEAD><BODY><P>This Load Script should do the trick for you:</P><P></P><P><IMG alt="2016-01-20 #1.PNG" class="jive-image image-1" src="/legacyfs/online/112109_2016-01-20 #1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 20 Jan 2016 12:31:28 GMT petter 2016-01-20T12:31:28Z Re-writing data from other source https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036507#M642373 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>In my test model i want to update data (Source1)&nbsp; from data (Source2)</P><P></P><P>If there're some existing YearWeeks from Source2, system must update NomId and Sales for it and add new data (not existing YearWeeks)</P><P></P><P>My necessary result table:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl63" height="20" width="64">YearWeek</TD><TD class="xl63" width="64">NomId</TD><TD class="xl63" width="64">Sales</TD></TR><TR><TD class="xl63" height="20">201501</TD><TD class="xl63">45</TD><TD class="xl63">34</TD></TR><TR><TD class="xl63" height="20">201501</TD><TD class="xl63">223</TD><TD class="xl63">4</TD></TR><TR><TD class="xl63" height="20">201502</TD><TD class="xl63">63</TD><TD class="xl63">44</TD></TR><TR><TD class="xl63" height="20">201503</TD><TD class="xl63">23</TD><TD class="xl63">234</TD></TR><TR><TD class="xl63" height="20">201504</TD><TD class="xl63">87</TD><TD class="xl63">424</TD></TR><TR><TD class="xl63" height="20">201505</TD><TD class="xl63">114</TD><TD class="xl63">35</TD></TR><TR><TD class="xl63" height="20">201506</TD><TD class="xl63">22</TD><TD class="xl63">66</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 20 Jan 2016 12:02:11 GMT https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036507#M642373 Anonymous 2016-01-20T12:02:11Z Re: Re-writing data from other source https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036508#M642374 <HTML><HEAD></HEAD><BODY><P>This Load Script should do the trick for you:</P><P></P><P><IMG alt="2016-01-20 #1.PNG" class="jive-image image-1" src="/legacyfs/online/112109_2016-01-20 #1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 20 Jan 2016 12:31:28 GMT https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036508#M642374 petter 2016-01-20T12:31:28Z Re: Re-writing data from other source https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036509#M642375 <HTML><HEAD></HEAD><BODY><P>Thanks so much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 20 Jan 2016 14:00:32 GMT https://community.qlik.com/t5/QlikView/Re-writing-data-from-other-source/m-p/1036509#M642375 Anonymous 2016-01-20T14:00:32Z