For loop to find largest number in table column.

Question

question

Kari Payton asked Sep 1, '17 Mischa Spelt commented Sep 5, '17

For loop to find largest number in table column.

Hi,

I need help writing a code that finds the highest value in a table's column. Here's my attempt but it returns a 0.

Table MainData = Table("MainDataTable");


int oldResult = 0;
int newResult = 0;


for( int row = 1; row<= Table("MainDataTable").numRows; row++)
	newResult = Table("MainDataTable")[row][1];
	if (newResult >= oldResult)
		oldResult = newResult;


return newResult;

Software Version:

FlexSim 17.2.1

code editor

tablecodehelp.png (5.4 KiB)

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Matthew Gillespie ♦♦ commented · Sep 01, 2017 at 05:14 PM

You could also do this very easily with a query:

return Table.query("SELECT * FROM MainDataTable ORDER BY [Col 1] DESC")[1][1];

0 ·

Mischa Spelt Matthew Gillespie ♦♦ commented · Sep 05, 2017 at 08:39 AM

Or, if you prefer not to use queries, you can use the findmax command (for more information, look it up in the command reference). For example, the following code assumes that you have a global table MyTable and want to find the maximum value in column 2:

Table table = Table("MyTable");
int maxOfColumn = 2;

// Returns the maximum value
return findmax(table.numRows, table[count][maxOfColumn]);

You can use the optional third parameter to return something else, for example if you want to know in which row the maximum occurs

// Returns the row containing the maximum value
return findmax(table.numRows, table[count][maxOfColumn], count);

2 ·

Answer 1 · 2017-09-01T16:34:23Z

Matthew Gillespie answered Sep 1, '17 Kari Payton commented Sep 1, '17

You need to return oldResult, not newResult, since that is where you're storing the current biggest number.

· 3

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Kari Payton commented · Sep 01, 2017 at 04:51 PM

@Matthew Gillespie

I tried that but still get a 0.largesttablenumhelp.fsm

0 ·

largesttablenumhelp.fsm (12.0 KiB)

Matthew Gillespie ♦♦ Kari Payton commented · Sep 01, 2017 at 05:10 PM

You need to put braces around everything you want the for loop to do, otherwise it just executes the first line over and over.

Table MainData = Table("MainDataTable");
int maxValue = 0;

for( int row = 1; row <= MainData.numRows; row++) {
	int curValue = MainData[row][1];
	if (curValue > maxValue)
		maxValue = curValue;
}
return maxValue;

(I renamed your variables for clarity)

1 ·

Kari Payton Matthew Gillespie ♦♦ commented · Sep 01, 2017 at 07:03 PM

ok got it. Thanks @Matthew Gillespie

0 ·

question