REMDOUBL# returns a Telitab subset from which multiple ocurring cases are removed

Syntax

  1. REMDOUBL#(Mode%, Telitab$,Deviation,[ArgPar_1$,..,ArgPar_n$])
  2. REMDOUBL#(Telitab$,[ArgPar_1$,..,ArgPar_n$])

Arguments 

  • Mode% is the way you want to remove or use double values:
    • Mode% = -2 inverse remove, will only leave the double values, keeping Deviation into account
    • Mode% = -1 standard remove of double values, removing all double values, keeping Deviation into account
    • Mode% = 0 standard remove of double values, leaving one case (the very first one...), keeping Deviation into account
    • Mode% > 0 standard remove of double values (comparable to Mode% = 0 ) but returning only the column with a number equal to Mode%, keeping Deviation into account
  • Telitab$ is a string expression containing table to be analysed.
  • Deviation is a very small value required for instance in order to compensate errors due to internal rounding

  • ArgPar_1$,,,,ArgPar_n$ is an optional list of parameter names in Telitab$ to base the REMDOUBL# on. 


Remarks

  1. By means of the Mode% in combination with Deviation, you are able to get specific sections from a dataset. 
  2. By standard (second syntax) any second case of a table for which the values of ArgPar_1$,,,,ArgPar_n$ are the same, is removed from the table. 
  3. If ArgPar_1$,,,,ArgPar_n$ is void, all parameters in the table should have the same value as in any previous case in order to be removed from the set.

Examples

When we use the relation:

REMDOUBL#(Telitab$, "SPEED","RPM")

for Telitab$:

0 
6 "RUN" "SPEED" "RPM" "TORQUE" "THRUST" 
"1" 5607401001 0.00 803.00 132.27 -39.32 
"2" 5607401002 0.35 835.69 133.02 -39.08 
"3" 5607401003 0.70 877.99 135.47 -39.23 
"4" 5607401004 1.39 903.04 118.85 -32.78 
"5" 5607401005 0.35 835.69 133.02 -39.08 
"6" 5607401006 2.10 902.16 92.47 -23.55 
"7" 5607401007 0.35 860.41 133.02 -39.08

Will return:

 

0 
6 "RUN" "SPEED" "RPM" "TORQUE" "THRUST" 
"1" 5607401001 0.00 803.00 132.27 -39.32 
"2" 5607401002 0.35 835.69 133.02 -39.08 
"3" 5607401003 0.70 877.99 135.47 -39.23 
"4" 5607401004 1.39 903.04 118.85 -32.78 
"5" 5607401006 2.10 902.16 92.47 -23.55 
"6" 5607401007 0.35 860.41 133.02 -39.08

Case 5 (row 5) is removed because SPEED and RPM are the same as in case 2.

Please note, REMDOUBL#(Telitab$) would return the complete Telitab$ as result due to the difference RUN numbers (also for cases 2 and 5).

 

Quick links: Functions overview | Attribute overview | Constants overview | Dimensions overview


 

  • No labels