topic Re: Data Modelling with 3 Main Tables in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/1110357#M911822 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>creating link table is the best way in my point of view.</P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Thu, 02 Jun 2016 04:46:10 GMT ajsjoshua 2016-06-02T04:46:10Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/1110356#M911821 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110356#M911821 microwin88x 2020-11-25T16:16:04Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110357#M911822 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>creating link table is the best way in my point of view.</P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Thu, 02 Jun 2016 04:46:10 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110357#M911822 ajsjoshua 2016-06-02T04:46:10Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110358#M911823 <HTML><HEAD></HEAD><BODY><P>There are more common fields between the tables then different ones so that I would very probably concatenate these tables. That's easy to implement and runs often faster then link-table approaches.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 02 Jun 2016 05:24:21 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110358#M911823 marcus_sommer 2016-06-02T05:24:21Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110359#M911824 <HTML><HEAD></HEAD><BODY><P>Link table is the best Approach or You can use concatenate or use left outer join to make it as single table .</P></BODY></HTML> Thu, 02 Jun 2016 06:06:24 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110359#M911824 Anonymous 2016-06-02T06:06:24Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110360#M911825 <HTML><HEAD></HEAD><BODY><P>Concatenate would be my recommendation.</P><P>You may also want to create a RECORD_TYPE field using the first character of ID_MAIN, or by adding a fixed value in the load script say 1 for Tasks, 2 for orders, 3 for Incidents so you can easily select Tasks, Orders or Incidents in your filters or set expressions.</P></BODY></HTML> Thu, 02 Jun 2016 11:32:57 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110360#M911825 Colin-Albert 2016-06-02T11:32:57Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110361#M911826 <HTML><HEAD></HEAD><BODY><P>I would go with concatenating the three tables as I'm sure you would see a better performance. </P></BODY></HTML> Thu, 02 Jun 2016 11:50:41 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110361#M911826 Anonymous 2016-06-02T11:50:41Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110362#M911827 <HTML><HEAD></HEAD><BODY><P>Thanks Colin.</P><P></P><P>The thing is if I need to check which orders/incidents have associated tasks, how would I do that if I use a single table? Because as I have it right now with the 3 tables by separate, from table TASKS I can know what ORDERS/INCIDENTS are associated to that task.</P></BODY></HTML> Thu, 02 Jun 2016 16:44:18 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110362#M911827 microwin88x 2016-06-02T16:44:18Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110363#M911828 <HTML><HEAD></HEAD><BODY><P>Load the Items and Tasks using</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ID_MAIN as ID_PARENT </P><P>Then you can filter on the Parent ID and the you will see all tasks and linked orders and items.</P><P>The link between the records should be on ID_PARENT not ID_MAIN.</P></BODY></HTML> Thu, 02 Jun 2016 16:53:53 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110363#M911828 Colin-Albert 2016-06-02T16:53:53Z Re: Data Modelling with 3 Main Tables https://community.qlik.com/t5/QlikView/Solved/m-p/1110364#M911829 <HTML><HEAD></HEAD><BODY><P>Thank you!!!</P></BODY></HTML> Thu, 02 Jun 2016 17:33:27 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1110364#M911829 microwin88x 2016-06-02T17:33:27Z