5.4.5. Collate

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.4. Join Tables >

5.4.5. Collate

 

Icon: clip0113

 
Function: collate
 

Property window:

 

ANATEL~3_img265

 

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|

    +------+------+---------+---------+---------+---------+

 

 

ANATEL~2_img8

NOTE:

You don't need any primary key at all.

The rows are placed in the order in which they “arrive”.