Concatenate

If two tables that are to be concatenated have different sets of fields, 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. An automatic concatenation occurs if two tables have the same field names.

Syntax:  

Concatenate[ (tablename ) ] ( loadstatement | selectstatement )

 

A concatenation is in principle the same as the SQL UNION statement, but with two differences:

• The Concatenate prefix can be used no matter if the tables have identical field names or not.
• Identical records are not removed with the Concatenate prefix.

Arguments:  

Example 1:  

LOAD * From file2.csv;

Concatenate SELECT * From table3;

Example 2:  

tab1:

LOAD * From file1.csv;

tab2:

LOAD * From file2.csv;

.. .. ..

Concatenate (tab1) LOAD * From file3.csv;