CalcIt Commands

MERGE(Arr1, Arr2, NumericMerge=true)

Merges two shorted arrays Arr1 and Arr2 and returns the array result. Merging can be with values considered as numeric or alphanumeric. The shorting (in case of alphanumeric) is over case insensitive values. If the arrays contain multi-field values SetArrField has to be applied first to Arr1 and Arr2 to define the field will be used for the merging. MERGE is the fastest and less resource intensive method to return a sorted array from other two already sorted.

See also Array Expressions, Multi-field values

Go Back