Contents - Index


$ClearLookup

 

The $ClearLookup directive is available in the Professional license.  It will clear data from the specified Lookup table with the option to specify the rows and/or columns that are to be cleared. 

 

The format of the $ClearLookup directive is

 

$ClearLookup  'LookupTableName'   /C2..5  /R1..10

 

'LookupTableName' is a string constant or string variable that provides the name of the Lookup table as it appears on the tab of the Lookup Table window

 

The /C and  /R are optional parameters.  

 

/C specify a range of columns, e.g., 1..10 that will be cleared.   A string variable can be used to provide the range, e.g., /CC$ where C$ contains the range.  If the range is not specified, then all columns in the table will be cleared for the specified range of columns.

 

/R specify a range of rows, e.g., 2..5 that will be cleared.   A string variable can be used to provide the range, e.g., /RR$ where R$ contains the range.  If the range is not specified, then all rows in the table will be cleared for the specified range of columns.  

 

The $ClearLookup directive is executed while the equations are being compiled, before the calculations are initiated.  Multiple $ClearLookup directives may be used.

 

Note that when used with the Solve Table command (or other solving commands that use the Parametric table), the $ClearLookup directive will normally be executed once before any of the runs in the Parametric table are executed.  If you need to clear the Lookup table before each run in the Parametric table, it will be necessary to recompile the equations for each run in the Parametric table.  This can be accomplished by placing a $Recompile directive before the $ClearLookup directive.

 

See also:  $CopytoLookup

 

Directives