Icon: 
Function: collate
Property window:
Short description:
Collate several tables.
Long Description:
The different tables will be glued together side-by-side.
Some empty rows can optionally be inserted at the beginning of the tables.
This Action is handy when manipulating time-series.
This Action is very similar to a simple Join Action (but it does not require any keys).
For example, if we have:
•The "delays" (that are defining the number of empty rows at the beginning of the table):
oPIN 1= 1 delay
oPIN 2= 3 delay
oPIN 3= 0 delay
• These input tables:
+-------------+ +-------------+ +-------------+
| TABLE 1 | | TABLE 2 | | TABLE 3 |
+------+------+ +------+------+ +------+------+
|Field1|field2| |Field1|field2| |Field1|field2|
+------+------+ +------+------+ +------+------+
| A| B| | C| D| | E| F|
| AA| BB| | CC| DD| | EE| FF|
| AAA| BBB| +------+------+ | EEE| FFF|
| AAAA| BBBB| | EEEE| FFFF|
+------+------+ | EEEEE| FFFFF|
|EEEEEE|FFFFFF|
+------+------+
...we obtain:
+-----------------------------------------------------+
| OUTPUT TABLE |
+------+------+---------+---------+---------+---------+
|Field1|field2|T1.Field1|T1.field2|T2.Field1|T2.field2|
+------+------+---------+---------+---------+---------+
| | | | | E| F|
| A| B| | | EE| FF|
| AA| BB| | | EEE| FFF|
| AAA| BBB| C| D| EEEE| FFFF|
| AAAA| BBBB| CC| DD| EEEEE| FFFFF|
| | | | | EEEEEE| FFFFFF|
+------+------+---------+---------+---------+---------+
NOTE:
You don't need any primary key at all.
The rows are placed in the order in which they “arrive”.