topic Re: Link Table in QlikView https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077323#M932435 <HTML><HEAD></HEAD><BODY><P>Why can't you simply concatenate the tables?</P></BODY></HTML> Wed, 02 Mar 2016 18:24:17 GMT Gysbert_Wassenaar 2016-03-02T18:24:17Z Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077322#M932431 <HTML><HEAD></HEAD><BODY><P>Hi Qlik heads</P><P>I have 3 tables D, C, B,</P><P>table D has&nbsp; BranchD, EMPIDD, DepartmentNumberD, ControlNumberD, ControlTypeD as fields</P><P>table C has BranchC, EMPIDC, DepartmentNumberC,ControlNumberC,ControlTypeC,PartNumberC as fields</P><P>here except part number all fields are same.</P><P>table B has BranchB, Part NumberB,PartDiscription,DepartB as fileds.</P><P>from this i need a link table which will give the output as</P><P>Branch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dept&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ControlNum&nbsp;&nbsp;&nbsp;&nbsp; ControlNumType&nbsp;&nbsp;&nbsp;&nbsp; PartDesc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PartNum<BR />20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1608&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1380234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ECR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RXcolal<BR />20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1608&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1380235&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ECR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CXCOLA<BR />20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1608&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1380234&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ECR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1245<BR />20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1608&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1380235&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ECR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6524</P><P></P><P></P><P></P><P>how to achieve this. I have tried some thing like on the attachment. please help me on this</P><P></P><P></P><P>Regards</P><P>John</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077322#M932431 2020-11-25T16:16:04Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077323#M932435 <HTML><HEAD></HEAD><BODY><P>Why can't you simply concatenate the tables?</P></BODY></HTML> Wed, 02 Mar 2016 18:24:17 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077323#M932435 Gysbert_Wassenaar 2016-03-02T18:24:17Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077324#M932436 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert Wassenaar for your prompt response.</P><P></P><P>I have provided a sample data of my issue , actually I have to 25 columns for&nbsp; D, C tables in those I have the above mentioned columns as common, in the third table B I have 10 columns in this 3 columns are common. the table C has the the size of [QVD size 1.16 GB] so ,</P><P></P><P>also the part number in the C may or may not exist in the table B, so is it ok with concatenate? </P></BODY></HTML> Wed, 02 Mar 2016 18:38:11 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077324#M932436 2016-03-02T18:38:11Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077325#M932437 <HTML><HEAD></HEAD><BODY><P>Yes, that's not a problem.</P></BODY></HTML> Wed, 02 Mar 2016 18:45:22 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077325#M932437 Gysbert_Wassenaar 2016-03-02T18:45:22Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077326#M932438 <HTML><HEAD></HEAD><BODY><P>I have done but no luck ,please find the attachment</P></BODY></HTML> Wed, 02 Mar 2016 18:49:29 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077326#M932438 2016-03-02T18:49:29Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077327#M932439 <HTML><HEAD></HEAD><BODY><P>Sorry, but I can't think of any <EM>logic</EM> that would create such a table. It just doesn't make sense to me. </P></BODY></HTML> Thu, 03 Mar 2016 10:52:06 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077327#M932439 Gysbert_Wassenaar 2016-03-03T10:52:06Z Re: Link Table https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077328#M932440 <HTML><HEAD></HEAD><BODY><P>oh ok thanks Gysbert Wassenaar.</P><P></P><P>Regards</P><P>John</P></BODY></HTML> Thu, 03 Mar 2016 12:17:41 GMT https://community.qlik.com/t5/QlikView/Link-Table/m-p/1077328#M932440 2016-03-03T12:17:41Z