Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

..

.

1 Reply
Not applicable
Author

From the Qlikview reference manual:

Concatenate

If two tables that are to be concatenated have different sets of Fields (page 169), concatenation of two

tables can still be forced with the concatenate prefix. This statement forces concatenation with an existing

named table or the latest previously created logical table.

The syntax is:

concatenate[ (tablename ) ] ( loadstatement | selectstatement )

Examples:

Concatenate load * from file2.csv;

Concatenate select * from table3;

tab1:

Load * from file1.csv;

tab2:

load * from file2.csv;

.. .. ..

Concatenate (tab1) load * from file3.csv;