• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Loop Functions

Read（3346） Label: loop operation,

esProc offers loop functions that perform loop operations.

 Compute an expression with each member of a sequence, and return the results Compute x with each member of the sequence and then compute the average of members of the new sequence Compute an expression with one or more specified records and return the results Perform logical AND operation over members of a sequence Compute concatenation of all sequence-type members Check whether a given data object is a member of a certain sequence Perform logical OR operation over members of a sequence Count the number of members of a sequence Compute sum of members of a sequence Compute difference between sequence-type members of the new sequence Find a record according to its primary key value Count the number of distinct members in a sequence Get the first non-null member in a sequence Compute intersection of the sequence-type members of a sequence Perform interative loop on a record sequence and return the result of the last calculation of a given expression Find the maximum value among members of a sequence Return the member that makes the maximum value for the expression Divide a sequence into multiple segments and return the specified bordering member(s) Find the minimum value among members of a sequence Return the member that makes the minimum value of the expression Get the most frequently appearing member from a sequence Get the first non-null and non-empty-string member from a sequence Find the ordinal number of a record by its primary key Return the ordinal numbers of members with the maximum value in a sequence Return the ordinal numbers of members with the minimum value in a sequence Get the position of a member in a sequence Get positions of members of a sequence in another sequence Compute the proportion of each member of a sequence Return the ordinal number of the interval in which the parameter falls Return the ordinal numbers of members that satisfy the query criterion Return the ordinal numbers of the sorted members in the original sequence Compute the specified expression(s) over each member of a sequence, sort the result members, and return ordinal numbers of the first n members in the original sequence Get the ranking of a specified value among members a sequence Get rankings of members of a sequence Compute one or more expressions with each member in a sequence and return the modified sequence Return the member in a sequence corresponding to a certain interval number Return members that make the value of the expression true Generate a new sequence by sorting the members of a sequence Compute sum of members of a sequence Compute an expression over each member of a sequence and return a sequence consisting of the first n members or values Compute the union of all sequence-type members in a sequence Generate a new sequence by uniting and rearranging distinct members in each of a sequence’s sub-sequences An iterative loop to get a cumulative value over records in which one of its fields has same values Get information about base members at a superior level in a multilayer loop function An iterative loop for calculating an expression Find a certain field of a specified row in a table sequence/in-memory table Find one or more records according to specified key value(s) Perform a loop operation by declaring an integer loop variable Compute expressions over a certain record and return result the last expression Compute an expression based on a record and return the modified record An iterative loop for numbering records according to the values of certain fields An iterative loop for numbering records according to the values of certain fields An iterative loop for numbering records in which a certain field contains same values Introduce the common rules of expressions in a loop function