4. 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 |
#--- COMBINAISON
TB3 = CALC_TABLE (TABLE = TB1,
ACTION =_F (OPERATION =' COMB ',
TABLE = TB2, NOM_PARA =' NOEUD '))
The contents of table TB3 are:
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