for each in Field

[#1]

Hi!

Is there a way iterating throug the records of a Field?

Like this:

LoadYears:
LOAD * INLINE [
LoadYear
2010
2005
2004
2003
2002
1998];

for each vYear in LoadYear

..do somethis with vYear;

next vYear

[#2 · Accepted solution]

Hi

I've used something like this successfully in the past:

Let noOfRows = NoOfRows('LoadYears');
for row= 1 to $(noOfRows)
let vYear=fieldvalue('LoadYear', $(row));
..do something with vYear;
next

Hope it helps

/Fredrik