Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

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
Nicole-Smith

table1:

LOAD a,b,c FROM...;

table2:

LOAD a,b FROM...;

concatenate(table1)

LOAD a,b FROM...;

View solution in original post

3 Replies
Nicole-Smith

table1:

LOAD a,b,c FROM...;

table2:

LOAD a,b FROM...;

concatenate(table1)

LOAD a,b FROM...;

poojashribanger
Creator II
Creator II


you can write like this

Table1:

load * from table;

concatenate(Table1)

load * from table;

noconcatenate

table2:

load * from table;

praveenkumar_ma
Partner - Creator
Partner - Creator

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