enum()

Read(206) Label: enumeration, group,

Here’s how to use enum() function.

P.enum()

Description:

Generate a new record sequence by performing enumeration grouping on an record sequence according to another record sequence.

Syntax:

P.enum(E, y)

Note:

The function generates a new record sequence by grouping the record sequence P according to the record sequence/sequence E.

Parameters:

P

Record sequence to be grouped

E

Record sequence/sequence

y

A field name or an expression in P. y is allowed to be omitted

Options:

@r

Repetitive enum, that is, allocate a certain record of P to multiple groups.

@p

The return value is composed of the sequence numbers of members that exist in P

@n

Group P’s records according to E’s members and return the result groups. In the result set, there is a group to store the unaligned member(s).

Function Keyword:

?

It represents the value of y

Return value:

The new record sequence generated by grouping P

Example:

Ø  E is a sequence

 

A

 

1

=["?<=60","?>=60 && ?<=90","?>=90"]

Use y to replace ? in the group condition when computing

2

=demo.query("select * from SCORES")

 

3

=A2.enum(A1,SCORE)

3 groups in total, and a member will not appear in multiple groups

4

=A2.enum@r(A1,SCORE)

3 groups in total; 60 and 90 are allocated to multiple groups

5

=A2.enum@p(A1,SCORE)

3 groups in total; return the sequence numbers of members that exist in A2 by group

6

=["?<=60","?>=60 && ?<=90"]

 

7

=A2.enum@n(A6,SCORE)

3 groups in total, group 1 for those not greater than 60, group 2 for those greater than 60 and not greater than 90, and group 3 for the remaining values.

Note:

p.enum() is mainly used to conduct the enum grouping on a single record sequence. The grouping result is a sequence composed of multiple record sets, and each record set is a group. This sequence is in an order exactly equal to that of E. Therefore, you can retrieve the associated group information from E via the sequence numbers. The group result is not a record sequence, so no new data structure will be generated

Related functions:

E.penum()