topic Dubble left keep in QlikView https://community.qlik.com/t5/QlikView/Dubble-left-keep/m-p/490416#M693549 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P></P><P>I'm got the following situation. </P><P></P><P>Table_Projects: contains al the project lines in the database. </P><P>Table_Machines: contains the Parts </P><P>Table_People contains the people people.</P><P></P><P>Table Projects is really big, To visualize what parts en people are working on a project I would like to Left join them both. </P><P></P><P></P><P>Example:</P><P>Table_Machines:</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_Parts.QVD</P><P></P><P>Table_People:</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_People.QVD</P><P></P><P></P><P>Table_project:</P><P>Left Keep Table_Machines</P><P>Left Keep Table_People</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_project.QVD</P><P></P><P></P><P>What is the most effective way to do this? </P><P></P><P></P><P>Regards,</P><P></P><P>Marco</P></BODY></HTML> Thu, 20 Jun 2013 07:16:33 GMT 2013-06-20T07:16:33Z Dubble left keep https://community.qlik.com/t5/QlikView/Dubble-left-keep/m-p/490416#M693549 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P></P><P>I'm got the following situation. </P><P></P><P>Table_Projects: contains al the project lines in the database. </P><P>Table_Machines: contains the Parts </P><P>Table_People contains the people people.</P><P></P><P>Table Projects is really big, To visualize what parts en people are working on a project I would like to Left join them both. </P><P></P><P></P><P>Example:</P><P>Table_Machines:</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_Parts.QVD</P><P></P><P>Table_People:</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_People.QVD</P><P></P><P></P><P>Table_project:</P><P>Left Keep Table_Machines</P><P>Left Keep Table_People</P><P>LOAD</P><P>Field 1</P><P>Field 2</P><P>Field 3</P><P>Etc.</P><P>FROM</P><P>DATA\QVD\Table_project.QVD</P><P></P><P></P><P>What is the most effective way to do this? </P><P></P><P></P><P>Regards,</P><P></P><P>Marco</P></BODY></HTML> Thu, 20 Jun 2013 07:16:33 GMT https://community.qlik.com/t5/QlikView/Dubble-left-keep/m-p/490416#M693549 2013-06-20T07:16:33Z Re: Dubble left keep https://community.qlik.com/t5/QlikView/Dubble-left-keep/m-p/490417#M693550 <HTML><HEAD></HEAD><BODY><P>Load Table_People</P><P>Left Join </P><P>Load Table_Machines</P><P>Left Join</P><P>Table_Projects</P><P></P><P>If you dont want to actually join the tables, go with keep instead of join.</P><P></P><P>Regards,</P><P>Abhijit</P></BODY></HTML> Thu, 20 Jun 2013 07:36:39 GMT https://community.qlik.com/t5/QlikView/Dubble-left-keep/m-p/490417#M693550 AbhijitBansode 2013-06-20T07:36:39Z