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:  

Argument Description
tablename The name of the existing table.

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;

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?