..

Anonymous — Fri, 30 May 2014 12:44:01 GMT

Re: Concatenation issue

Fri, 30 May 2014 12:46:10 GMT

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;