Return value from second column based on value queried.

[suraj_j]

Hello

I can't recollect if there is a function that returns a value from 2nd column of global table based on value that is given in first column.

e.g. From following data, if I enter 'SomeFunc("Table",0.8) I would get 190 (rounded above).

.25	100
.5	150
.75	175
1.0	190

I know about d/c/empirical. The number in first column is not random but calculated.

Any help is appreciated.

[SCHamoen · Accepted solution]

@Suraj J

As far as I know there is not. But it is very simple to create your own usercommand and have this function. Something like this would do:

double value = param(1);

for( int i = 1; i <= Table("TheTable").numrows; i++ )
{
	if( Table("TheTable")[1] >= value)
	{
		return Table[2];
	}
}

[suraj_j]

I guess I have to take this route then.

[joerg_vogel_HsH]

You get your return value by an Table.query.

Table.query("SELECT target FROM TheTable WHERE input >= $1 ORDER BY input ASC", col1Value)[1][1];

The Reset trigger contains more lines of code, because I want to show how you get the value. Line 7 is the code you need. Attached is the model in Flexsim 18.1.1.

query-table-for-return.fsm