IterNo - script function

This script function returns an integer indicating the current iteration within a while clause. The first iteration has number 1. The IterNo function is only meaningful if used together with a while clause.

Syntax:  

IterNo( )

Examples and results:  

LOAD

   IterNo() as Day,

   Date( StartDate + IterNo() - 1 ) as Date

   While StartDate + IterNo() - 1 <= EndDate;

 

LOAD * INLINE

[StartDate, EndDate

2014-01-22, 2014-01-26

];

 

This LOAD statement will generate one record per date within the range defined by StartDate and EndDate.

In this example, the resulting table will look like this: