topic Link Table creation: use concatenate or outer join? in QlikView https://community.qlik.com/t5/QlikView/Link-Table-creation-use-concatenate-or-outer-join/m-p/98090#M603348 <HTML><HEAD></HEAD><BODY><P>hi guys, </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">i am creating a link table.... i see alot of articles when guiding on creating linktable , it uses Concatenate..</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">but, actually can we just Outer Join instead of Concatenate??? what is the difference? i really need some help to differentiate it to apply in the link table....</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">rgds</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">jim</SPAN></P></BODY></HTML> Fri, 12 Oct 2018 07:03:08 GMT jim_chan 2018-10-12T07:03:08Z Link Table creation: use concatenate or outer join? https://community.qlik.com/t5/QlikView/Link-Table-creation-use-concatenate-or-outer-join/m-p/98090#M603348 <HTML><HEAD></HEAD><BODY><P>hi guys, </P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">i am creating a link table.... i see alot of articles when guiding on creating linktable , it uses Concatenate..</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">but, actually can we just Outer Join instead of Concatenate??? what is the difference? i really need some help to differentiate it to apply in the link table....</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">rgds</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">jim</SPAN></P></BODY></HTML> Fri, 12 Oct 2018 07:03:08 GMT https://community.qlik.com/t5/QlikView/Link-Table-creation-use-concatenate-or-outer-join/m-p/98090#M603348 jim_chan 2018-10-12T07:03:08Z Re: Link Table creation: use concatenate or outer join? https://community.qlik.com/t5/QlikView/Link-Table-creation-use-concatenate-or-outer-join/m-p/98091#M603349 <HTML><HEAD></HEAD><BODY><P>A link-table contains usually the key-values of several tables within a single key-field and this will be reached by concatenating these values repectively tables and not by adding further fields. I think there are not many scenarios in which a join approach might be useful to create a link-table.</P><P></P><P>Beside this you should rather avoid link-tables because they are often not necessary and have in regard to the needed efforts and performance disadvantages against a (official recommended) star-scheme datamodel.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 12 Oct 2018 07:46:10 GMT https://community.qlik.com/t5/QlikView/Link-Table-creation-use-concatenate-or-outer-join/m-p/98091#M603349 marcus_sommer 2018-10-12T07:46:10Z