Functions for Associative Operations

Read(2521) 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.groupi(Di,…)

Generate a sequence based on a multilayer dimension cell in a data-input sheet

Ø  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.merge()

Merge multiple table sequences/record sequences

Ø  new(xi:Fi,…)

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


Perform computations on a sequence and generate a new table sequence


 Compute each member of a sequence according to the specified condition to generate multiple records and concatenate them into a new table sequence

Ø  A.pivot()

Perform row-to-column transposition for a sequence

Ø  E.penum()

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

Ø  P.align(A:x,y)

Align records of a record sequence to another sequence

Ø  P.align(n,y)

Perform alignment grouping for a 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.fjoin()

Perform foreign-key-style association on a table sequence/record sequence

Ø  P.join()

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

Ø  A.pjoin()

Create association between multiple table sequences/record sequences through the join key

Ø  P.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

Ø  P.nodes()

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

Ø  j()

Join multiple sequences according to positions and return a pure table sequence

Ø  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

Ø  x.nodes@r()

Expand the referencing field(s) through multilevel of recursion