General

General Functions: CombinedDimension Create a new discrete string field by joining up to 6 discrete fields together.   Field Values are separated with underscores. . Purpose Use this function to: Build unique keys for creating joins Crea...

General Functions: CombinedDimension_NS Create a new discrete field from the concatenated string values for field 1 to 6. No separator is used to delimit the component values. Purpose Use this function to: Build unique keys for creating joins...

General: CombinedIndex Create a new discrete integer field by multiplexing the unique values for fields 1 up to 6. All unique Value|value… combinations for the source fields are combined as strings and then the resulting values are assigned a un...

General: CompositeLongKey Combined the specified low (L) and high(H) continuous integer fields into a continuous long integer field. The intermediate field is defined as (L*M)+H Purpose Use this function to: Combine two Integer keys int...

General: CopyDiscrete Makes a copy of the discrete source field. The function will not work if used with a continuous DataType.   It works with all FieldTypes.  Purpose Use this function to: Remove unwanted values from a disc...

General: CopyDiscreteIndex Returns a copy of the source discrete index, filtered by the optional dataset. Creates an Integer field with values 1 to N, where N is the number of discrete values in the source field.  Purpose Use this func...

General: DescendingIndex Assigns an integer to each unique value in the field, working in reverse order. Creates an Integer field with values N to 1, where N is the number of discrete values in the source field.  Purpose Use this funct...

General: DiscreteIntegerSequence Produces a field that is the record number in a table, stored as a discrete integer Purpose Use this function to: Create a unique primary key on an existing table of less than 1 million rows Identify and sel...

General: DistinctByKey Create a flag field, set to true for the first occurrence of each unique value of a key field, for the set of records linked to each key in a primary table. Purpose Use this function to: Flag records grouped by their...

General: FirstDiscrete Creates a flag field where the first occurrence of each unique value in the specified field is set to 1. Purpose Use this function to: Gain a count of how many discrete values of a field there are in RecordSet Ident...

General: FirstDiscreteByIndex Creates a flag field where the first occurrence of each unique value in the specified field is set to 1 – but derived as if the table is in order of the sort field Purpose Use this function to: Sort Data by a ...

General: FirstDiscreteByInvertedIndex Creates a flag field where the first occurrence of each unique value in the specified field is set to 1 – but derived as if the table by in descending order of the sort field. Purpose Use this function to:...

General: IntegerSequenceKey Produces a field that is the record number in a table, stored as a continuous integer. Purpose Use this function to: Create a unique primary key on an existing table Identify and select specific records by numb...

General: JoinLayers Join Analysis Functions Purpose Use these functions to: Count the number of layers that matched for each record in a join Find the first layer that matched for a record Obtain the binary value of matching layers Get a ...

General: LongSequenceKey Produces a field that is the record number in a table, stored as a continuous long integer Purpose Use this function to: Create a unique primary key on an existing table where the number of records may exceed 2 bil...

General: MakeContinuousKey Produces a new continuous integer field from a discrete field of any data type Purpose Use this function to: Create a continuous field from a discrete field so that it can be used to join with a continuous field ...

General: Quantile Groups data into a specified number of segments, where each segment contains the same number of records. Purpose Use this function to: Group data into relative ranks Create percentiles, quartiles etc Return Value ...

General: SessionIdentifier On a foreign (many-side) table, for the set of records corresponding to each key in the primary (one-side) table, create a sequence counter (an integer discrete field) for each set of records where the elapsed timestamp ...