topic Re: Data from two tables in QlikView https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395988#M147672 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Sat, 05 Jan 2013 14:00:03 GMT Gysbert_Wassenaar 2013-01-05T14:00:03Z Data from two tables https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395986#M147670 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN class="hps">I have </SPAN><SPAN class="hps">two </SPAN><SPAN class="hps">tables </SPAN><SPAN class="hps">and I need to </SPAN><SPAN class="hps">get </SPAN><SPAN class="hps">to </SPAN><SPAN class="hps">the Ventas table </SPAN><SPAN class="hps">the value </SPAN><SPAN class="hps">of the Price field </SPAN><SPAN class="hps">in the table</SPAN><SPAN class="hps"> Costos, </SPAN><SPAN class="hps">as shown in the</SPAN> <SPAN class="hps">image</SPAN>.</P><P></P><P><IMG __jive_id="28726" class="jive-image-thumbnail jive-image" onclick="" alt="img.bmp" src="https://community.qlik.com/legacyfs/online/28726_img.bmp" width="450" /></P><P><SPAN class="hps">I</SPAN> <SPAN class="hps">need to do it</SPAN> <SPAN class="hps">in the</SPAN> <SPAN class="hps">script</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the following result</SPAN></P><P><SPAN class="hps"><IMG __jive_id="28727" class="jive-image-thumbnail jive-image" onclick="" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/28727_Captura.PNG" width="450" /></SPAN></P></BODY></HTML> Sat, 05 Jan 2013 13:05:50 GMT https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395986#M147670 spividori 2013-01-05T13:05:50Z Re: Data from two tables https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395987#M147671 <HTML><HEAD></HEAD><BODY><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-size: 10pt;">Hi Sandro,</SPAN></P><P></P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="font-size: 10pt;">Try this script:</SPAN></P><P style="font-size: 9px; font-family: 'Courier New';"><BR /><SPAN style="font-size: 10pt;"> <SPAN style="color: #0433ff;"><STRONG>Directory</STRONG></SPAN>;</SPAN><BR /><SPAN style="font-size: 10pt;"> Ventas:</SPAN><BR /><SPAN style="font-size: 10pt;"> <SPAN style="color: #0433ff;"><STRONG>LOAD</STRONG></SPAN> <SPAN style="color: #941100;">Item</SPAN>, </SPAN><BR /><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #941100;">Codigo</SPAN> <SPAN style="color: #0433ff;">as</SPAN> <SPAN style="color: #941100;">VentasCodigo</SPAN>, </SPAN><BR /><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #941100;">Fecha</SPAN> <SPAN style="color: #0433ff;">as</SPAN> <SPAN style="color: #941100;">VentasFecha</SPAN></SPAN><BR /><SPAN style="color: #0433ff; font-size: 10pt;"> FROM</SPAN><BR /><SPAN style="font-size: 10pt;"> Ventas.xlsx</SPAN><BR /><SPAN style="font-size: 10pt;"> (<SPAN style="color: #0433ff;">ooxml</SPAN>, <SPAN style="color: #0433ff;">embedded</SPAN> <SPAN style="color: #0433ff;">labels</SPAN>, <SPAN style="color: #0433ff;">table</SPAN> <SPAN style="color: #0433ff;">is</SPAN> Hoja1);</SPAN><BR /> <BR /> <BR /><SPAN style="font-size: 10pt;"> <SPAN style="color: #0433ff;"><STRONG>Directory</STRONG></SPAN>;</SPAN><BR /><SPAN style="font-size: 10pt;"> Costos:</SPAN><BR /><SPAN style="font-size: 10pt;"> <SPAN style="color: #0433ff;">left</SPAN> <SPAN style="color: #0433ff;">keep</SPAN> (Ventas)</SPAN><BR /><SPAN style="font-size: 10pt;"> <SPAN style="color: #0433ff;"><STRONG>LOAD</STRONG></SPAN> <SPAN style="color: #941100;">Item</SPAN>, </SPAN><BR /><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #941100;">Codigo</SPAN> <SPAN style="color: #0433ff;">as</SPAN> <SPAN style="color: #941100;">CostosCodigo</SPAN>, </SPAN><BR /><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #941100;">Precio</SPAN>, </SPAN><BR /><SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #941100;">Fecha</SPAN> <SPAN style="color: #0433ff;">as</SPAN> <SPAN style="color: #941100;">CostosFecha</SPAN></SPAN><BR /><SPAN style="color: #0433ff; font-size: 10pt;"> FROM</SPAN><BR /><SPAN style="font-size: 10pt;"> Costos.xlsx</SPAN><BR /><SPAN style="font-size: 10pt;"> (<SPAN style="color: #0433ff;">ooxml</SPAN>, <SPAN style="color: #0433ff;">embedded</SPAN> <SPAN style="color: #0433ff;">labels</SPAN>, <SPAN style="color: #0433ff;">table</SPAN> <SPAN style="color: #0433ff;">is</SPAN> Hoja1);</SPAN><BR /> <BR />&nbsp; </P></BODY></HTML> Sat, 05 Jan 2013 13:50:29 GMT https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395987#M147671 2013-01-05T13:50:29Z Re: Data from two tables https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395988#M147672 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Sat, 05 Jan 2013 14:00:03 GMT https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395988#M147672 Gysbert_Wassenaar 2013-01-05T14:00:03Z Re: Data from two tables https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395989#M147673 <HTML><HEAD></HEAD><BODY><P>HI.</P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Thanks, it's</SPAN> <SPAN class="hps">what I needed</SPAN>!</SPAN></P><P></P><P><SPAN class="short_text" lang="en">Regards.<BR /></SPAN></P></BODY></HTML> Mon, 07 Jan 2013 13:29:15 GMT https://community.qlik.com/t5/QlikView/Data-from-two-tables/m-p/395989#M147673 spividori 2013-01-07T13:29:15Z