topic JOINS in QlikView https://community.qlik.com/t5/QlikView/JOINS/m-p/1240932#M394061 <HTML><HEAD></HEAD><BODY><P>I have an issue I am related to JOINING table.&nbsp; Currently, I have two table I am try to JOIN but cannot achieve outcome I would like.&nbsp; Ultimately, I want to create a table that contains everything from Table 1 and Talbe 2 in the example attached.&nbsp; In the end, if a PROVIDER in Table 2 only performs service 1,2,3 and 5, I want the Final Table to contain all Services from 1 - 6 eventhough the PROVIDER didn;t have any data in Table 2.&nbsp; Is that possible?&nbsp; If so, how would accomplish it?&nbsp; See examples attached.</P></BODY></HTML> Thu, 12 Jan 2017 19:29:36 GMT bxprokop 2017-01-12T19:29:36Z JOINS https://community.qlik.com/t5/QlikView/JOINS/m-p/1240932#M394061 <HTML><HEAD></HEAD><BODY><P>I have an issue I am related to JOINING table.&nbsp; Currently, I have two table I am try to JOIN but cannot achieve outcome I would like.&nbsp; Ultimately, I want to create a table that contains everything from Table 1 and Talbe 2 in the example attached.&nbsp; In the end, if a PROVIDER in Table 2 only performs service 1,2,3 and 5, I want the Final Table to contain all Services from 1 - 6 eventhough the PROVIDER didn;t have any data in Table 2.&nbsp; Is that possible?&nbsp; If so, how would accomplish it?&nbsp; See examples attached.</P></BODY></HTML> Thu, 12 Jan 2017 19:29:36 GMT https://community.qlik.com/t5/QlikView/JOINS/m-p/1240932#M394061 bxprokop 2017-01-12T19:29:36Z Re: JOINS https://community.qlik.com/t5/QlikView/JOINS/m-p/1240933#M394062 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>have a look at the attach example</P></BODY></HTML> Thu, 12 Jan 2017 20:01:16 GMT https://community.qlik.com/t5/QlikView/JOINS/m-p/1240933#M394062 lironbaram 2017-01-12T20:01:16Z