Concatenate disadvantage

[alis2063]

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



Regards,
Ali

[Gysbert_Wassenaar]

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.

[alis2063]

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

[Vegar]

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