Concatenate in QlikView

Concatenatation in QlikView

Concatenate functionality in QlikView is the load script and it is used for data modelling. When we load two tables in the Qlikview and if there is same number of the fields, then the table gets loaded as single table and they are concatenate to each other.

And if they are not in the same field then we have to force concatenate to them then this concatenate is called Forced Concatenate. In this we get single table but if field not matched then its data is also not matched then in this we get blank space in the columns.

There are different ways of the concatenation in Qlikview data modelling.

  1. Concatenate
  2. Forced Concatenate
  3. No Concatenate

As explain told you the term concatenate is use in the data modelling and it is the strong functions which can used for table concatenation so it is also the way to make perfect data model and to remove synthetic keys from the tables.