Functions for Associative Operations

Read(984) Label: associative operation,

  The following are functions that deal with esProc associative operations.

Ø  A.derive()

Add one or more fields to a table sequence/record sequence


Perform equi-grouping according to one or more fields or expressions


Group a sequence and then perform aggregate operations

Ø  A.groups() 

Group a table sequence and then get the aggregating result cumulatively


Perform merging and sorting, then the distinct operation on a sequence, and return the result of distinct

Ø  A.join()

A foreign-key-style join between table sequences/record sequences, or a table sequence and a record sequence

Ø  A.merge()

Merge multiple table sequences/record sequences

Ø  E()

Convert a string, two-level sequence, table sequence or record sequence to a specific type

Ø  E()

Switch between an Excel date/time value and a numeric value

Ø  new(xi:Fi,…)

Generate a record according to the specified field name and field value


Generate a new table sequence/record sequence, whose field values are computed from the field values of a table sequence/record sequence


Compute field values based on a table sequence/record sequence, and concatenate them to generate a new one

Ø  A.pivot()

Perform row-to-column transposition for a sequence

Ø  A.switch()

Switch the values of the reference field between the corresponding primary key values and the referenced records, or, sometimes switch between them in a reverse direction

Ø  E.penum()

Judge to which enum group of a record sequence a field value or an expression belongs, and return the serial number(s) of the group(s) satisfying the grouping criterion

Ø  P.align()

Align the records of a record sequence to another sequence or record sequence by the join fields and then sort them, so as to group the record sequence

Ø  P.derive()

Generate a table sequence according to a record sequence

Ø  P.enum()

Generate a new record sequence by performing enumeration grouping on a record sequence according to another record sequence of conditional expressions

Ø  P.nodes()

Find records in a recursive way where the foreign key values reference a specified record

Ø  join()

Join multiple sequences together

Ø  r.prior()

Among the records, query fields referred by the foreign key recursively

Ø  xjoin()

Perform a cross join on multiple sequences

Ø  xjoinx()

Perform cross join over single cursors or table sequences