topic Re: Concatenate disadvantage in QlikView

Concatenate disadvantage

alis2063 — Mon, 21 Jan 2019 17:42:59 GMT

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

Regards,
Ali

Re: Concatenate disadvantage

Gysbert_Wassenaar — Mon, 21 Jan 2019 17:58:15 GMT

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.

Re: Concatenate disadvantage

alis2063 — Mon, 21 Jan 2019 18:04:46 GMT

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

Re: Concatenate disadvantage

Vegar — Mon, 21 Jan 2019 21:48:15 GMT

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