4. 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 |
#--- COMBINAISON
TB3=CALC_TABLE(TABLE=TB1,
ACTION =_F(OPERATION='COMB',
TABLE = TB2, NOM_PARA='NOEUD'))
Le contenu de la table TB3 est :
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