Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

concatenate a specified table

Is there a way to concatenate a specified table? For example:

If my script is like:

table1:

LOAD a,b,c FROM...;

table2:

LOAD a,b FROM...;

If I do:

CONCATENATE LOAD a FROM..., it will automatically concatenate table2. What if I want to concatenate table1?

Thanks in advance!

1 Solution

Accepted Solutions

Re: concatenate a specified table

table1:

LOAD a,b,c FROM...;

table2:

LOAD a,b FROM...;

concatenate(table1)

LOAD a,b FROM...;

3 Replies

Re: concatenate a specified table

table1:

LOAD a,b,c FROM...;

table2:

LOAD a,b FROM...;

concatenate(table1)

LOAD a,b FROM...;

poojashribanger
Contributor II

Re: concatenate a specified table


you can write like this

Table1:

load * from table;

concatenate(Table1)

load * from table;

noconcatenate

table2:

load * from table;

praveenkumar_ma
Contributor

Re: concatenate a specified table

Hi Yang,

Even if two or more tables do not have exactly the same set of fields, it is still possible to force Qlik Sense to concatenate the two tables. This is done with the concatenate prefix in the script, which concatenates a table with another named table or with the last previously created table.

Example:

LOAD a, b, c from table1.csv;

concatenate LOAD a, c from table2,csv;

The resulting internal table has the fields a, b and c. The number of records in the resulting table is the sum of the numbers of records in table 1 and table 2. The value of field b in the records coming from table 2 is NULL.

This will help you i guess...

Regards

PM