Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld
Usage:
FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld
[WorkWith], Destination, Function, Source1, Source2, Source3, Source4, Options, [""]
[WorkWith], Destination, Function, Source1, Source2, Source3, [""], Options, [""]
[WorkWith], Destination, Function, Source1, Source2, [""], [""], Options, [""]
[WorkWith], Destination, Function, Source1, [""], [""], [""], Options, [""]
[WorkWith], Destination, Function, Source1, [""], [""], [""], [""], [""]
FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, Source3, Source4, Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, Source3, [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, Source2, [""], [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, [""], [""], [""], Options, [WorkIf]
[WorkWith], Destination, Function, Source1, [""], [""], [""], [""], [WorkIf]
Description:
An optimized way to perform geographic calculations in bulk on multiple records simultaneously.
Evaluates the Function and places the requested value into the Destination Field.
List of Functions:
Note: This toolset has been designed for speed and simplicity over precision. All calculations performed are approximate and do not perfectly take into account the earth's geography.
Example:
LoadTable "MemTab.Contact"
Children "Finance.LineItem"
NewFields "EstDistance"
Geo "EstDistance", "Distance", "MemTab.Contact.Lat", "MemTab.Contact.Long", "Finance.LineItem.Lat", "Finance.LineItem.Long", ""
KeepIf "EstDistance", ">>", 40 'KM