topic Re: Concatenate and Join in QlikView https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502119#M1126803 <HTML><HEAD></HEAD><BODY><P>Common scenarios are ...</P><P></P><P>concatenate: two or more tables contain the same fields and you want to bring them together into a single table</P><P></P><P>left join: two or more tables have a single common key and you want to bring additional fields from one or more child tables into a master table</P><P></P><P>association (the QlikView default): this is essentially a many-to-many join and very powerful; you will use this option 90% of the time</P><P></P><P>mapping load and applymap(): similar to a left join but often more efficient in terms of CPU</P></BODY></HTML> Wed, 18 Dec 2013 13:52:18 GMT 2013-12-18T13:52:18Z Concatenate and Join https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502117#M1126801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can any body give me scenariou is that where concatenate is used than join and same as join is useful&nbsp; than concatenate.</P><P></P><P>give me business scenariou.</P><P></P><P>regards</P><P>Mahesh T</P></BODY></HTML> Wed, 18 Dec 2013 13:46:41 GMT https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502117#M1126801 2013-12-18T13:46:41Z Re: Concatenate and Join https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502118#M1126802 <HTML><HEAD></HEAD><BODY><P>See this document: <A href="https://community.qlik.com/qlik-blogpost/2375">Understanding Join, Keep and Concatenate </A></P></BODY></HTML> Wed, 18 Dec 2013 13:48:09 GMT https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502118#M1126802 Gysbert_Wassenaar 2013-12-18T13:48:09Z Re: Concatenate and Join https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502119#M1126803 <HTML><HEAD></HEAD><BODY><P>Common scenarios are ...</P><P></P><P>concatenate: two or more tables contain the same fields and you want to bring them together into a single table</P><P></P><P>left join: two or more tables have a single common key and you want to bring additional fields from one or more child tables into a master table</P><P></P><P>association (the QlikView default): this is essentially a many-to-many join and very powerful; you will use this option 90% of the time</P><P></P><P>mapping load and applymap(): similar to a left join but often more efficient in terms of CPU</P></BODY></HTML> Wed, 18 Dec 2013 13:52:18 GMT https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502119#M1126803 2013-12-18T13:52:18Z Re: Concatenate and Join https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502120#M1126804 <HTML><HEAD></HEAD><BODY><P>Hi Mahesh,</P><P></P><P>Please find the attachment copy of document..</P></BODY></HTML> Wed, 18 Dec 2013 16:47:41 GMT https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502120#M1126804 2013-12-18T16:47:41Z Re: Concatenate and Join https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502121#M1126805 <HTML><HEAD></HEAD><BODY><P>Thank u.</P></BODY></HTML> Wed, 18 Dec 2013 18:46:55 GMT https://community.qlik.com/t5/QlikView/Concatenate-and-Join/m-p/502121#M1126805 2013-12-18T18:46:55Z