Concatenation

Sometimes you come across a situation while building the data model where you may have to append one table below another. In such situations, you can use the concatenate function. Concatenating, as the name suggest, helps to add the records of one table below another. Concatenate is different from joins. Unlike joins, concatenate does not merge the matching records of both the tables in a single row.

Automatic concatenation

In Qlik Sense, when the numbers of columns in two tables are same and the naming of those columns are same, Qlik Sense, by default, concatenates those tables without any explicit command. This is called the automatic concatenation.

For example, you may get the customer information from two...