topic Joining two separate workbooks in QlikView https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372991#M419367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two different worksheet in a single excel namely</P><P><BR />1.&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Sales</STRONG> with following columns - </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 717px;"><TBODY><TR><TD class="xl67" height="20" width="71"><SPAN style="color: #ff6600;"><STRONG>Date</STRONG></SPAN></TD><TD class="xl65" style="border-left: none;" width="88">Particulars</TD><TD class="xl65" style="border-left: none;" width="162">Location / Workcentre</TD><TD class="xl68" style="border-left: none;" width="103"> Stock </TD><TD class="xl65" style="border-left: none;" width="43"><STRONG style="color: #ff6600;">Co.</STRONG></TD><TD class="xl69" style="border-left: none;" width="59">Week</TD><TD class="xl65" style="border-left: none;" width="93">Item Group</TD><TD class="xl69" style="border-left: none;" width="98">Dept</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 10pt;">2.&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Stock</STRONG> with following columns</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 288px;"><TBODY><TR><TD class="xl65" height="20" width="43"><STRONG style="color: #ff6600;">Co.</STRONG></TD><TD class="xl65" style="border-left: none;" width="71"><STRONG style="color: #ff6600;">Date</STRONG></TD><TD class="xl65" style="border-left: none;" width="77">Export</TD><TD class="xl65" style="border-left: none;" width="97">Remarks</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Column header highlighted namely - <STRONG style="color: #ff6600;">Date and Co.</STRONG> are common in both worksheets, </SPAN></P><P><SPAN style="font-size: 10pt;">HOw do i connect both in same?</SPAN></P><P><SPAN style="font-size: 10pt;">Please help.</SPAN></P><P></P><P>Thanks,</P><P>Vikas</P></BODY></HTML> Sat, 25 Nov 2017 08:46:32 GMT vikas_nandanwar 2017-11-25T08:46:32Z Joining two separate workbooks https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372991#M419367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two different worksheet in a single excel namely</P><P><BR />1.&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Sales</STRONG> with following columns - </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 717px;"><TBODY><TR><TD class="xl67" height="20" width="71"><SPAN style="color: #ff6600;"><STRONG>Date</STRONG></SPAN></TD><TD class="xl65" style="border-left: none;" width="88">Particulars</TD><TD class="xl65" style="border-left: none;" width="162">Location / Workcentre</TD><TD class="xl68" style="border-left: none;" width="103"> Stock </TD><TD class="xl65" style="border-left: none;" width="43"><STRONG style="color: #ff6600;">Co.</STRONG></TD><TD class="xl69" style="border-left: none;" width="59">Week</TD><TD class="xl65" style="border-left: none;" width="93">Item Group</TD><TD class="xl69" style="border-left: none;" width="98">Dept</TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 10pt;">2.&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Stock</STRONG> with following columns</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 288px;"><TBODY><TR><TD class="xl65" height="20" width="43"><STRONG style="color: #ff6600;">Co.</STRONG></TD><TD class="xl65" style="border-left: none;" width="71"><STRONG style="color: #ff6600;">Date</STRONG></TD><TD class="xl65" style="border-left: none;" width="77">Export</TD><TD class="xl65" style="border-left: none;" width="97">Remarks</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Column header highlighted namely - <STRONG style="color: #ff6600;">Date and Co.</STRONG> are common in both worksheets, </SPAN></P><P><SPAN style="font-size: 10pt;">HOw do i connect both in same?</SPAN></P><P><SPAN style="font-size: 10pt;">Please help.</SPAN></P><P></P><P>Thanks,</P><P>Vikas</P></BODY></HTML> Sat, 25 Nov 2017 08:46:32 GMT https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372991#M419367 vikas_nandanwar 2017-11-25T08:46:32Z Re: Joining two separate workbooks https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372992#M419368 <HTML><HEAD></HEAD><BODY><P>Two Approaches are covered in mt script. Check attached</P></BODY></HTML> Sat, 25 Nov 2017 09:09:40 GMT https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372992#M419368 Anil_Babu_Samineni 2017-11-25T09:09:40Z Re: Joining two separate workbooks https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372993#M419369 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P>this worked</P><P>Vikas</P></BODY></HTML> Sat, 25 Nov 2017 09:59:15 GMT https://community.qlik.com/t5/QlikView/Joining-two-separate-workbooks/m-p/1372993#M419369 vikas_nandanwar 2017-11-25T09:59:15Z