Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi can any body explain iterno() function with simple example
Iterno() only makes sense if used together with while. You can autogenerate rows, for example for creating a calendar, or creating records from another table. A real example would be having a table with mortgages contracts containing only the initial payment. With iterno() / while and some business rules you can generate the complete amortization tables,
an easy example would be:
Example:
Load iterno() as Counter
AutoGenerate 1
While iterno() < 10;
regards
Maybe
LOAD
Iterno() as RowNumber
autogenerate 1 While iterno() <=10;
From the HELP:
This function is only meaningful if used together with a while clause, see Load. IterNo( ) 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.
You can search the forum for iterno(), there are plenty of threads that use this function.
Iterno() only makes sense if used together with while. You can autogenerate rows, for example for creating a calendar, or creating records from another table. A real example would be having a table with mortgages contracts containing only the initial payment. With iterno() / while and some business rules you can generate the complete amortization tables,
an easy example would be:
Example:
Load iterno() as Counter
AutoGenerate 1
While iterno() < 10;
regards