topic Re: Data model issue. in QlikView https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390493#M145640 <HTML><HEAD></HEAD><BODY><P>not sure I understand: do you need Phys_name on that table instead of the other one, or do you need to be able to slice data in both tables by that same field? If it's the first, then it should be dead easy using either APPLYMAP or a simple JOIN. If it's the latter, you need a link table in the middle which has the key and the shared attribute.</P></BODY></HTML> Mon, 25 Mar 2013 22:47:29 GMT 2013-03-25T22:47:29Z Data model issue. https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390492#M145639 <HTML><HEAD></HEAD><BODY><P>Please look at the attached snapshot, I need Phys_Name in Doctors Table also.</P></BODY></HTML> Mon, 25 Mar 2013 22:03:17 GMT https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390492#M145639 2013-03-25T22:03:17Z Re: Data model issue. https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390493#M145640 <HTML><HEAD></HEAD><BODY><P>not sure I understand: do you need Phys_name on that table instead of the other one, or do you need to be able to slice data in both tables by that same field? If it's the first, then it should be dead easy using either APPLYMAP or a simple JOIN. If it's the latter, you need a link table in the middle which has the key and the shared attribute.</P></BODY></HTML> Mon, 25 Mar 2013 22:47:29 GMT https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390493#M145640 2013-03-25T22:47:29Z Re: Data model issue. https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390494#M145641 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Add this script:</P><P></P><P>JOIN (Doctors)</P><P>LOAD DISTINCT</P><P>&nbsp;&nbsp; DoctorKey,</P><P>&nbsp;&nbsp; phys_name</P><P>RESIDENT [ACP Detail Charges];</P><P></P><P>Regards,</P><P>Ricardo</P></BODY></HTML> Mon, 25 Mar 2013 22:56:14 GMT https://community.qlik.com/t5/QlikView/Data-model-issue/m-p/390494#M145641 2013-03-25T22:56:14Z