Exemples
========


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


+-------------------------------------------------+
| **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'))

Le contenu de la table TB3 est :

.. 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


    #--- Formule

    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'))


    Le contenu de la 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')))


    Le contenu de la 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.))


    Le contenu de la 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')))


    Le contenu de la 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'))


    Le contenu de la 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=('maxi','somm'),

    )

    )


    Le contenu de la table TB1est :

N YZ NOEUD TYPE_CALCUL
0 2.0 4.5 N01-
14.017.5N03-
217.59.0 N06-
217.5-- maxi
323.5 - - somm



    TB1_new=CALC_TABLE(TABLE = TB1

    ACTION =_F(OPERATION='CALCUL',

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

    TYPE_CALCUL=('maxi','somm'),

    )

    )


    Le contenu de la table TB1_NEWest :

N YTYPE_CALCUL
217.5maxi
323.5 somm