topic Re: common fields in QlikView https://community.qlik.com/t5/QlikView/common-fields/m-p/391506#M146031 <HTML><HEAD></HEAD><BODY><P>use: </P><P></P><P>Qualifier key word:</P><P></P><P>tab1:</P><P>load</P><P>from X</P><P></P><P>qualify *;</P><P>tab2</P><P>load</P><P>from y</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 21 May 2013 11:43:16 GMT sushil353 2013-05-21T11:43:16Z common fields https://community.qlik.com/t5/QlikView/common-fields/m-p/391505#M146030 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to create a table&nbsp; which contains the common fields of two other tables.</P><P>How can I do that?</P></BODY></HTML> Tue, 21 May 2013 11:40:03 GMT https://community.qlik.com/t5/QlikView/common-fields/m-p/391505#M146030 2013-05-21T11:40:03Z Re: common fields https://community.qlik.com/t5/QlikView/common-fields/m-p/391506#M146031 <HTML><HEAD></HEAD><BODY><P>use: </P><P></P><P>Qualifier key word:</P><P></P><P>tab1:</P><P>load</P><P>from X</P><P></P><P>qualify *;</P><P>tab2</P><P>load</P><P>from y</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 21 May 2013 11:43:16 GMT https://community.qlik.com/t5/QlikView/common-fields/m-p/391506#M146031 sushil353 2013-05-21T11:43:16Z Re: common fields https://community.qlik.com/t5/QlikView/common-fields/m-p/391507#M146032 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>a really short question. Do you have an example explaining your intension?</P><P>Best Sacho</P></BODY></HTML> Tue, 21 May 2013 11:54:45 GMT https://community.qlik.com/t5/QlikView/common-fields/m-p/391507#M146032 2013-05-21T11:54:45Z Re: common fields https://community.qlik.com/t5/QlikView/common-fields/m-p/391508#M146033 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Hope this is what u desire:</P><P></P><P>Temp1:</P><P>Load a,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c</P><P>from temp1.qvd;</P><P></P><P>Join (Temp2)</P><P>Load b,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d</P><P>from temp2.qvd;</P><P></P><P>Temp:</P><P>load b, c resisdent Temp1;</P><P></P><P>Drop table Temp1;</P><P></P><P>I am just wildly guessing the solution as i can't understand your requirements.</P><P></P><P>regards,</P></BODY></HTML> Tue, 21 May 2013 12:10:09 GMT https://community.qlik.com/t5/QlikView/common-fields/m-p/391508#M146033 gaurav2017 2013-05-21T12:10:09Z