Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Link Table creation: use concatenate or outer join?

hi guys,

i am creating a link table.... i see alot of articles when guiding on creating linktable , it uses Concatenate..

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....



1 Reply
MVP & Luminary
MVP & Luminary

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.

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.

- Marcus