CalculateTables Class

Initializes a new instance of the class to calculate fields in a data table. Inherits AddTables.

CalculateTables(array options)

Option	Type	Description
ViewName	string	Use an already opened view
ViewNames	array	An array of options of two already opened view names and join fields. Name: Name of the view Field: Name of the field for the join
TableNames	array	An array of options of two table or layer files Name: Layer or table file name Field: Name of the field for the join

AddFields (opt)		Add output fields to the tables FieldSpecs: Array of arrays of fieldname, field type and optional width and decimals Table: Optional for joined tables. Right or left tables. Default is left

Name	Type	Contents
Filter	string	Optional. Name of the selection set filter
GetView		Returns the name of the view

ApplyFilter( filter )

Filters the data for the calculations.

Option		Type	Description
filter		string	Selection set query

ClearFilter()

Removes current filter.

ClearOperations()

Clear all configured operations.

Option		Type	Description
FormulaName		string	Name of the temporary dataview field containing the formula

ClearOperations()

Clear all configured operations.

AddFormula(opts)

Create a temporary formula that can be used for the fill operation. It returns the formula name.

Option		Type	Description
opts		array
	FormulaName	string	Name of the temporary dataview field containing the formula
	Formula	string	Formula definition

Operation(opt)

Definition of the fill operation.

Option		Type	Description
opts		array
	FieldName	string	Name of the output field name
	Formula	string	Fill operation formula definition

Calculate()

Perform the fill operation

Statistics(opts)

Returns a summary statistics for the field.

Option		Type	Description
opts		array
	FieldName	string	Name of the output field name
	Method	string	Optional. Default value is 'Sum'. Same options as macro function VectorStatistic.
	Options	array	Optional. Same options as macro function VectorStatistic.