topic Re: Real time scenario on join/concatenate usage in QlikView https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451413#M809811 <HTML><HEAD></HEAD><BODY><P>Any other answers please to understand&nbsp; much better ?</P></BODY></HTML> Mon, 16 Oct 2017 10:56:35 GMT pradeep92 2017-10-16T10:56:35Z Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451410#M809808 <HTML><HEAD></HEAD><BODY><P>‌</P><P style="color: #000000; font-family: HelveticaNeue, 'Helvetica Neue', sans-serif; font-size: 16px;">Hi , I understood very well on how join and concatenate works but when is the situation to be used in real time ? </P><P style="color: #000000; font-family: HelveticaNeue, 'Helvetica Neue', sans-serif; font-size: 16px;">Also is the outer join and concatenate is the same if there are no matching records ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451410#M809808 pradeep92 2020-11-25T16:16:04Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451411#M809809 <HTML><HEAD></HEAD><BODY><P>In your data model suppose the two tables are exactly same or maybe few fields only different then go for concatenate.</P><P></P><P>1. When to use outer join (let assume in your two tables few fields are common or may be composite keys are there then you have to go for the Outer join also concatenate works)</P><P>2. If more fields are common or may be exactly same then it is concatenated.</P><P>3. In qlik when you reload and due to qlik engines if found two fields in table are same then it is auto concatenate.</P></BODY></HTML> Sat, 14 Oct 2017 15:30:35 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451411#M809809 its_anandrjs 2017-10-14T15:30:35Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451412#M809810 <HTML><HEAD></HEAD><BODY><P>Yeah. As per my understanding, when there are so much of matching fields between tables then go for concatenate else join. But how does the data look like ?</P></BODY></HTML> Mon, 16 Oct 2017 07:30:12 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451412#M809810 pradeep92 2017-10-16T07:30:12Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451413#M809811 <HTML><HEAD></HEAD><BODY><P>Any other answers please to understand&nbsp; much better ?</P></BODY></HTML> Mon, 16 Oct 2017 10:56:35 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451413#M809811 pradeep92 2017-10-16T10:56:35Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451414#M809812 <HTML><HEAD></HEAD><BODY><P>Please read carefully and do practical - <A href="https://community.qlik.com/thread/39177">Understanding Join, Keep and Concatenate</A></P></BODY></HTML> Mon, 16 Oct 2017 10:58:45 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451414#M809812 Anil_Babu_Samineni 2017-10-16T10:58:45Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451415#M809813 <HTML><HEAD></HEAD><BODY><P>Data is treated as a single table then and available in one table also you can differentiated it with the flag fields to identify data is for which table.</P></BODY></HTML> Mon, 16 Oct 2017 11:04:34 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451415#M809813 its_anandrjs 2017-10-16T11:04:34Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451416#M809814 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Mon, 16 Oct 2017 11:53:39 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451416#M809814 pradeep92 2017-10-16T11:53:39Z Re: Real time scenario on join/concatenate usage https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451417#M809815 <HTML><HEAD></HEAD><BODY><P>Some of this you can read also for your help on your topics.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7520">Different Join Functions in Qlikview</A></P><P><A href="https://community.qlik.com/docs/DOC-7457">Some Qlikview Joins,Keep,Concatenation and Applymap best documents</A></P></BODY></HTML> Mon, 16 Oct 2017 12:28:50 GMT https://community.qlik.com/t5/QlikView/Real-time-scenario-on-join-concatenate-usage/m-p/1451417#M809815 its_anandrjs 2017-10-16T12:28:50Z