topic Re: Which join is best when combining two tables with multiple common fields in QlikView https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410112#M802137 <HTML><HEAD></HEAD><BODY><P>The business needs and nature of the data will determine whether you should join, concatenate or link these tables. There is no correct abstract/theoretical answer to your question.</P></BODY></HTML> Fri, 17 Nov 2017 05:10:32 GMT jonathandienst 2017-11-17T05:10:32Z Which join is best when combining two tables with multiple common fields https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410110#M802133 <HTML><HEAD></HEAD><BODY><P>I have two tables and first table has A, B, C, D ,E as common with the second table A, B, C ,D, E. </P><P></P><P>I have to create a logical link between the two tables . What is the script to create this logical link. </P><P></P><P>AND should a Join be used to link these tables - what is the best join used to achieve this - is the best solution an Outer join as it will consider rows from both tables. </P><P></P><P>Awaiting solution. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410110#M802133 Anonymous 2020-11-25T16:16:04Z Re: Which join is best when combining two tables with multiple common fields https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410111#M802135 <HTML><HEAD></HEAD><BODY><P>Not sure, Why Link Table table concept needed here. When we have common fields it merge into single table .</P></BODY></HTML> Fri, 17 Nov 2017 04:14:15 GMT https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410111#M802135 Anil_Babu_Samineni 2017-11-17T04:14:15Z Re: Which join is best when combining two tables with multiple common fields https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410112#M802137 <HTML><HEAD></HEAD><BODY><P>The business needs and nature of the data will determine whether you should join, concatenate or link these tables. There is no correct abstract/theoretical answer to your question.</P></BODY></HTML> Fri, 17 Nov 2017 05:10:32 GMT https://community.qlik.com/t5/QlikView/Which-join-is-best-when-combining-two-tables-with-multiple/m-p/1410112#M802137 jonathandienst 2017-11-17T05:10:32Z