sticky
Sticky refers to a value, such as a row number or the number of rows in a worksheet, that remains persistent despite changes to the current worksheet.
For instance, a sticky row number for a particular row is determined from the current
worksheet at a given evaluation point in the query. A sticky row number will not change
regardless of whether the number of rows or relative position of that row changes due to
operations performed on that worksheet after the evaluation point. There are three
sticky system values: i_()
, ii_()
, and
n_()
.
As an example, consider a row that was the 100th row in a base table but which is the 5th row after a transformation. The sticky row number for that row would still be 100.
- System Variables in the 1010data Reference Manual