topic Re: find max value of a field in App Development

find max value of a field

lmenendez_grupo_pinero — Mon, 28 Feb 2022 10:54:53 GMT

How could I capture the maximum value of a field into a variable in order to use it into a loop

Something like this:

set lastrow=max(RowID);

for n=1 to lastrow

...

Thanks

Re: find max value of a field

chris_djih — Mon, 28 Feb 2022 10:58:10 GMT

you need to make a teporary table for this:
temp: Load Max(RowID) as max_RowId resident table;
Then you can give this value in your variable with Peek():
let lastrow = Peek('max_RowId',-1);

Re: find max value of a field

maxgro — Mon, 28 Feb 2022 11:06:35 GMT

If you want to loop on the rows of Table1 and get for every row the value of Field1

Table1:
LOAD * INLINE [
Field1
1
2
3
10
4
5
];

FOR r=0 TO NoOfRows('Table1')-1
LET vField1 = PEEK('Field1', $(r), 'Table1');
TRACE $(r) $(vField1);
NEXT

Re: find max value of a field

maxgro — Mon, 28 Feb 2022 11:08:46 GMT

IF you want to get the max value of Field1 and loop from 1 to max value of Field1

Table1:
LOAD * INLINE [
Field1
1
2
3
10
4
5
];

TMP:
LOAD MAX(Field1) AS Field1Max RESIDENT Table1;
LET vMax = Peek('Field1Max');

FOR i=1 TO $(vMax)
TRACE $(i);
NEXT

Re: find max value of a field

lmenendez_grupo_pinero — Mon, 28 Feb 2022 11:09:10 GMT

Thank for your usefull and quikly help.