Return value from second column based on value queried.

Question

question

Suraj J asked Jun 07 2018 at 1:38 PM Joerg Vogel answered Jun 08 2018 at 7:44 AM

Return value from second column based on value queried.

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.

global table lookup

Answer 1 · 2018-06-07T13:52:21Z

Steven Hamoen answered Jun 07 2018 at 1:52 PM Joerg Vogel commented Jun 08 2018 at 4:30 AM

@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")[i][1] >= value)
	{
		return Table[i][2];
	}
}

· 1

Answer 2 · 2018-06-08T07:44:35Z

Joerg Vogel answered Jun 08 2018 at 7:44 AM

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

returnvalue-from-table-by-query.jpg (353.1 KiB)

query-table-for-return.fsm (17.4 KiB)

question