Examples
========


+---------------------+-----+-----+---------+
|**Table** **' TB1 '**                      |
+---------------------+-----+-----+---------+
|**N**                |**Y**|**Z**|**NOEUD**|
+---------------------+-----+-----+---------+
|0                    |2.0  |4.5  |NO1      |
+---------------------+-----+-----+---------+
|1                    |4.0  |17.5 |N03 ROAD |
+---------------------+-----+-----+---------+
|2                    |17.5 |9.0  |N06 ROAD |
+---------------------+-----+-----+---------+


+---------------------+-----+-----+---------+
|**Table** **' TB2 '**                      |
+---------------------+-----+-----+---------+
|**N**                |**X**|**Z**|**NOEUD**|
+---------------------+-----+-----+---------+
|1                    |2.0  |2.5  |NO1      |
+---------------------+-----+-----+---------+
|3                    |4.0  |5.5  |N031     |
+---------------------+-----+-----+---------+
|4                    |17.5 |20.5 |N062     |
+---------------------+-----+-----+---------+
|6                    |5.0  |8.0  |N013     |
+---------------------+-----+-----+---------+


.. code-block:: text

    #--- COMBINAISON

    TB3 = CALC_TABLE (TABLE = TB1,

    ACTION =_F (OPERATION =' COMB ',

    TABLE = TB2, NOM_PARA =' NOEUD '))

The contents of table TB3 are:

.. code-block:: text


    N Y Z NOEUD X

    1 2.00000E+00 2.50000E+00 N01 2.00000E+00

    1 4.00000E+00 1.75000E+01 N03 -

    2 1.75000E+01 9.00000E+00 N06 -

    3 - 5.50000E+00 N031 4.00000E+00

    4 - 2.05000E+01 N062 1.75000E+01

    6 - 8.00000E+00 N013 5.00000E+00


    #--- Formula

    DNOR = FORMULE (NOM_PARA = ('X', 'Z'),

    VALE = 'sqrt (X*X+Z*Z) ')


    TB3 = CALC_TABLE (TABLE = TB3,

    reuse = TB3,

    ACTION =_F (OPERATION =' OPER ',

    FORMULE =dnor, NOM_PARA =' NOR_COOR '))


    The contents of table TB3est:


    N Y Z NOEUD X NOR_COOR

    1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00

    1 4.00000E+00 1.75000E+01 N03 - -

    2 1.75000E+01 9.00000E+00 N06 - -

    3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00

    4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01

    6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00


    #--- RENOMMER

    TB3 = CALC_TABLE (TABLE = TB3,

    reuse = TB3,

    ACTION =_F (OPERATION =' RENOMME ',

    NOM_PARA =( 'NOR_COOR', 'NORM_XZ', '')))


    The contents of table TB3est:


    N Y Z NOEUD X NORM_XZ

    1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00

    1 4.00000E+00 1.75000E+01 N03 - -

    2 1.75000E+01 9.00000E+00 N06 - -

    3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00

    4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01

    6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00


    #--- FILTRE

    TB4 = CALC_TABLE (TABLE = TB3,

    ACTION =_F (OPERATION =' FILTRE ',

    NOM_PARA =' NORM_XZ ', CRIT_COMP ='LE', VALE =30.))


    The contents of table TB4est:


    N Y Z NOEUD X NORM_XZ

    1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00

    3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00

    4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01

    6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00


    #--- EXTRACTION

    TB3 = CALC_TABLE (TABLE = TB3, reuse= TB3,

    ACTION =_F (OPERATION =' EXTR ',

    NOM_PARA =( 'NOEUD', 'X', 'Z', 'NORM_XZ')))


    The contents of table TB3est:

NOEUD X Z NORM_XZ
N01 2.00000E+00 2.50000E+00 3.20156E+00
N03 - 1.75000E+01 -
N06 - 9.00000E+00 -
N031 4.00000E+00 5.50000E+00 6.80074E+00
N062 1.75000E+01 2.05000E+01 2.69537E+01
N013 5.00000E+00 8.00000E+00 9.43398E+00


    #--- TRI

    TB3 = CALC_TABLE (TABLE = TB3, reuse= TB3,

    ACTION = _F (OPERATION =' TRI ',

    NOM_PARA =' NORM_XZ ', ORDRE =' DECROISSANT'))


    The contents of table TB3est:

NOEUD X Z NORM_XZ
N062 1.75000E+01 2.05000E+01 2.69537E+01
N013 5.00000E+00 8.00000E+00 9.43398E+00
N031 4.00000E+00 5.50000E+00 6.80074E+00
N01 2.00000E+00 2.50000E+00 3.20156E+00
N06 - 9.00000E+00 -
N03 - 1.75000E+01 -


    #--- CALCUL

    TB1 = CALC_TABLE (TABLE = TB1, reuse= TB1,

    ACTION =_F (OPERATION =' CALCUL ',

    NOM_PARA =( 'N', 'Y'),

    TYPE_CALCUL =( 'max', 'sum'),

    )

    )


    The contents of table TB1est:

N YZ NOEUD TYPE_CALCUL
0 2.0 4.5 N01-
14.017.5N03-
217.59.0 N06-
217.5-- max
33.5 - - sum



    TB1_new = CALC_TABLE (TABLE = TB1

    ACTION =_F (OPERATION =' CALCUL ',

    NOM_PARA =( 'N', 'Y'),

    TYPE_CALCUL =( 'max', 'sum'),

    )

    )


    The contents of table TB1_NEWest:

N YTYPE_CALCUL
217.5 max
33.5 sum