This section describes functions related to record counters during LOAD statement evaluation in the data load script. The only function that can be used in chart expressions is RowNo().
Some counter functions do not have any parameters, but the trailing parentheses are however
still required.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
This script function returns a unique integer value for each distinct evaluated value of
expression encountered during
the script execution. This function can be used e.g. for creating a compact
memory representation of a complex key.
This script function calculates
a 128-bit hash of the combined input expression values and the returns
a unique integer value for each distinct hash value encountered during
the script execution. This function can be used for example for creating a compact
memory representation of a complex key.
This script function calculates
a 256-bit hash of the combined input expression values and returns a unique
integer value for each distinct hash value encountered during the script
execution. This function can be used e.g. for creating a compact memory
representation of a complex key.
This script function returns an integer indicating for which time one single record
is evaluated in a LOAD statement
with a while clause. The first
iteration has number 1. The IterNo function is only meaningful if used together with a while clause.
RowNo() returns the number of the current row within the current column segment
in a table. For bitmap charts, RowNo() returns the number of the current row within the chart's straight table equivalent.
The load script is a sequence of statements that defines what data to load and how to link the different loaded tables. It can be generated with the Data manager, or with the Data load editor, where it also can be viewed and edited.
