Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Concatenate disadvantage

Can anybody tell me what is the disadvantage of Concatenate function in QlikView .



Regards,
Ali
3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Concatenating tables can be used to create a data model that may not be as easy to understand by business analysts as a data model that uses a link table instead of concatenated fact tables.
In some cases concatenating may be slower than joining tables.

talk is cheap, supply exceeds demand
Highlighted
Creator II
Creator II

I don’t thinks that Concatenate is slower than join or link.

Because in the join,we perform the relation or association between the tables based on key .
But Concatenate is used to append the data in tables.

Regards,
Ali
Highlighted
Partner
Partner

Concatenate is a quite useful function when you need to concatenate two tables into a single one. Use it if you need it.

It will however break your optimized load (if you had one).

Plees ekskuse my Swenglish and or Norweglish spelling misstakes