topic join problem in QlikView https://community.qlik.com/t5/QlikView/join-problem/m-p/340183#M125595 <HTML><HEAD></HEAD><BODY><P>hi gurus,</P><P></P><P>i have 3 excel files.</P><P></P><P>1. f1,1/1/2012</P><P>2.f1,1/1/2012</P><P>3.f1,1/1/2012</P><P></P><P></P><P>f1= sales,revenue,% diff</P><P></P><P>1/1/2012=numbers which are corresponding to sales,revenue,gross.</P><P></P><P></P><P style="text-align: left;"><SPAN style="text-decoration: underline;">structure example:</SPAN></P><P></P><P>f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2012 </P><P>sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $1000</P><P>revenue&nbsp;&nbsp;&nbsp; $2000</P><P>diffin %&nbsp;&nbsp;&nbsp; 50%</P><P></P><P></P><P>how can i load 3 excels to associate each other</P><P></P><P></P><P>plz help me to achieve the desired result.</P><P></P><P></P><P>Thank u in advance</P></BODY></HTML> Wed, 07 Mar 2012 11:52:34 GMT 2012-03-07T11:52:34Z join problem https://community.qlik.com/t5/QlikView/join-problem/m-p/340183#M125595 <HTML><HEAD></HEAD><BODY><P>hi gurus,</P><P></P><P>i have 3 excel files.</P><P></P><P>1. f1,1/1/2012</P><P>2.f1,1/1/2012</P><P>3.f1,1/1/2012</P><P></P><P></P><P>f1= sales,revenue,% diff</P><P></P><P>1/1/2012=numbers which are corresponding to sales,revenue,gross.</P><P></P><P></P><P style="text-align: left;"><SPAN style="text-decoration: underline;">structure example:</SPAN></P><P></P><P>f1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2012 </P><P>sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $1000</P><P>revenue&nbsp;&nbsp;&nbsp; $2000</P><P>diffin %&nbsp;&nbsp;&nbsp; 50%</P><P></P><P></P><P>how can i load 3 excels to associate each other</P><P></P><P></P><P>plz help me to achieve the desired result.</P><P></P><P></P><P>Thank u in advance</P></BODY></HTML> Wed, 07 Mar 2012 11:52:34 GMT https://community.qlik.com/t5/QlikView/join-problem/m-p/340183#M125595 2012-03-07T11:52:34Z join problem https://community.qlik.com/t5/QlikView/join-problem/m-p/340184#M125596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If all the 3 files has the same structure , then concatenate all the tables into one.</P><P></P><P>TableName:</P><P>LOAD</P><P>*</P><P>FROM File1;</P><P></P><P></P><P>CONCATENATE</P><P>LOAD</P><P>*</P><P>FROM File2;</P><P></P><P>CONCATENATE</P><P>LOAD</P><P>*</P><P>FROM File3;</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 07 Mar 2012 12:02:32 GMT https://community.qlik.com/t5/QlikView/join-problem/m-p/340184#M125596 jagan 2012-03-07T12:02:32Z