topic Re: Joining Two QVD in QlikView https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371999#M419214 <HTML><HEAD></HEAD><BODY><P>It is working ... PFA..</P></BODY></HTML> Wed, 09 Aug 2017 04:37:44 GMT prma7799 2017-08-09T04:37:44Z Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371987#M419202 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I need your help. I can't continue working on Qlikview as I'm&nbsp; receiving errors as I load the script.</P><P></P><P>Here's the error:</P><P><STRONG>Table not found error</STRONG></P><P><STRONG>Table 'MainTable' not found</STRONG></P><P><STRONG>LEFT JOIN ([MainTable])</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM ProjectTeam.qvd(qvd)</STRONG></P><P><STRONG><BR /></STRONG></P><P>For your reference I will give you my current script:</P><P><STRONG>[MainTable]:</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM Projects.qvd(qvd);</STRONG></P><P><STRONG>LEFT JOIN ([MainTable])</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM ProjectTeam.qvd(qvd);</STRONG></P><P></P><P><STRONG>STORE [MainTable] INTO MainTable.qvd;</STRONG></P><P><STRONG><BR /></STRONG></P><P>THANKS FOR HELPING!</P></BODY></HTML> Wed, 09 Aug 2017 03:29:50 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371987#M419202 ksomosera10 2017-08-09T03:29:50Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371988#M419203 <HTML><HEAD></HEAD><BODY><P>Remove Square Brackets and Try?</P></BODY></HTML> Wed, 09 Aug 2017 03:31:26 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371988#M419203 Anil_Babu_Samineni 2017-08-09T03:31:26Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371989#M419204 <HTML><HEAD></HEAD><BODY><P>I've removed all Square Brackets but error still persists. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 09 Aug 2017 03:33:57 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371989#M419204 ksomosera10 2017-08-09T03:33:57Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371990#M419205 <HTML><HEAD></HEAD><BODY><P>What you gave the script, Try this and let me know</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">MainTable:</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">LOAD * </STRONG><STRONG style="font-style: inherit; font-family: inherit;">FROM Projects.qvd (qvd);</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">LEFT JOIN (MainTable)</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">LOAD * </STRONG><STRONG style="font-style: inherit; font-family: inherit;">FROM ProjectTeam.qvd (qvd);</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">//STORE [MainTable] INTO MainTable.qvd;</STRONG></P></BODY></HTML> Wed, 09 Aug 2017 03:37:28 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371990#M419205 Anil_Babu_Samineni 2017-08-09T03:37:28Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371991#M419206 <HTML><HEAD></HEAD><BODY><P>I still get the error.</P><P></P><P><STRONG>Table not found error</STRONG></P><P><STRONG>Table 'MainTable' not found</STRONG></P><P><STRONG>LEFT JOIN (MainTable)</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM ProjectTeam.qvd(qvd)</STRONG></P></BODY></HTML> Wed, 09 Aug 2017 03:40:37 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371991#M419206 ksomosera10 2017-08-09T03:40:37Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371992#M419207 <HTML><HEAD></HEAD><BODY><P>Please share QVD's?</P></BODY></HTML> Wed, 09 Aug 2017 03:45:01 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371992#M419207 Anil_Babu_Samineni 2017-08-09T03:45:01Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371993#M419208 <HTML><HEAD></HEAD><BODY><P>It's a bit large. I could give you my script generating each qvd's if you want</P></BODY></HTML> Wed, 09 Aug 2017 03:47:44 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371993#M419208 ksomosera10 2017-08-09T03:47:44Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371994#M419209 <HTML><HEAD></HEAD><BODY><P>Try same way with inline table for 5 records from each qvd and check. Because, It loads easy manner when you used Left to the Table using Join</P></BODY></HTML> Wed, 09 Aug 2017 03:49:28 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371994#M419209 Anil_Babu_Samineni 2017-08-09T03:49:28Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371995#M419210 <HTML><HEAD></HEAD><BODY><P>Please share your application with 15 line debug or share qvd for at least 20 records</P></BODY></HTML> Wed, 09 Aug 2017 03:53:01 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371995#M419210 prma7799 2017-08-09T03:53:01Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371996#M419211 <HTML><HEAD></HEAD><BODY><P>Can you tell me how I can send qvd's here?</P></BODY></HTML> Wed, 09 Aug 2017 03:58:41 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371996#M419211 ksomosera10 2017-08-09T03:58:41Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371997#M419212 <HTML><HEAD></HEAD><BODY><P><IMG alt="qvd1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172859_qvd1.png" style="height: 319px; width: 620px;" /></P><P><IMG alt="qvd2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/172860_qvd2.png" style="height: 284px; width: 620px;" /></P></BODY></HTML> Wed, 09 Aug 2017 04:06:47 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371997#M419212 prma7799 2017-08-09T04:06:47Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371998#M419213 <HTML><HEAD></HEAD><BODY><P>Hi Here it is.</P></BODY></HTML> Wed, 09 Aug 2017 04:29:45 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371998#M419213 ksomosera10 2017-08-09T04:29:45Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371999#M419214 <HTML><HEAD></HEAD><BODY><P>It is working ... PFA..</P></BODY></HTML> Wed, 09 Aug 2017 04:37:44 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1371999#M419214 prma7799 2017-08-09T04:37:44Z Re: Joining Two QVD https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1372000#M419215 <HTML><HEAD></HEAD><BODY><P>Hey! It works! Thanks! </P><P>Just for my learning... Why the tab went advance on Main tab and what is the explanation? It'll be great so that I know how you do it. thanks again!</P></BODY></HTML> Wed, 09 Aug 2017 05:11:45 GMT https://community.qlik.com/t5/QlikView/Joining-Two-QVD/m-p/1372000#M419215 ksomosera10 2017-08-09T05:11:45Z