Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
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;