topic Re: NN relationship in QlikView https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458812#M171271 <HTML><HEAD></HEAD><BODY><P>Sorry guys,</P><P></P><P>I was given the wrong information by the DBA.</P><P>It worked fine with simple links when I had the right information...</P><P></P><P>Thanks for answering.</P><P></P><P>Clement</P></BODY></HTML> Tue, 11 Jun 2013 13:37:31 GMT Anonymous 2013-06-11T13:37:31Z NN relationship https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458809#M171268 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a NN join with 3 tables. I can't find how to load the data in qlikview so that it works.</P><P>The tables are "Relation", "<SPAN style="color: #383838; font-family: Arial, sans-serif;">Delivery_Points</SPAN>" and "Services"</P><P></P><P>Here is the description of the join :</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #383838;">[Relation]TableSource= 123 (table number [Delivery_Points])<BR />[Relation][Relation]SourceField= 12 (Field number [<SPAN style="color: #383838; font-family: Arial, sans-serif;">Delivery_Points</SPAN>]Number)</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Arial','sans-serif'; color: #383838;"><BR /></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #383838;">[Relation]TableDest=29</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #383838;">(Table number [SERVICES])</SPAN><SPAN style="font-size: 12.0pt; font-family: 'Arial','sans-serif'; color: #383838;"><BR /></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #383838;">[Relation]FieldDest = 1</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #383838;">(Filed number [SERVICES]Number)</SPAN></P><P></P><P>If anyone can help...</P><P></P><P>Cheers,</P><P></P><P>Clement</P></BODY></HTML> Tue, 11 Jun 2013 08:07:47 GMT https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458809#M171268 Anonymous 2013-06-11T08:07:47Z Re: NN relationship https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458810#M171269 <HTML><HEAD></HEAD><BODY><P>Can you provide some example of data from each of the three source tables and an example of how you are expecting the output to look in Qlikview?</P></BODY></HTML> Tue, 11 Jun 2013 11:52:02 GMT https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458810#M171269 RedSky001 2013-06-11T11:52:02Z Re: NN relationship https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458811#M171270 <HTML><HEAD></HEAD><BODY><P>I'm not sure i undersand your description of the join,</P><P>but I think for a NN join you use the prefix 'FULL OUTER JOIN' before your 2nd and 3rd LOAD</P></BODY></HTML> Tue, 11 Jun 2013 12:01:08 GMT https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458811#M171270 2013-06-11T12:01:08Z Re: NN relationship https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458812#M171271 <HTML><HEAD></HEAD><BODY><P>Sorry guys,</P><P></P><P>I was given the wrong information by the DBA.</P><P>It worked fine with simple links when I had the right information...</P><P></P><P>Thanks for answering.</P><P></P><P>Clement</P></BODY></HTML> Tue, 11 Jun 2013 13:37:31 GMT https://community.qlik.com/t5/QlikView/NN-relationship/m-p/458812#M171271 Anonymous 2013-06-11T13:37:31Z