Multiply two tables

Question

question

Pieter Cecat asked Mar 24, '17 Pieter Cecat commented Mar 24, '17

Multiply two tables

How can I most easily multiply the values of two global tables in a new table?

1/ when dimensions of both tables are the same.

2/ when a table has many rows but only 1 has to be multiplied with another table with 1 row.

Thanks in advance!

Software Version:

FlexSim 16.0.8

dashboards global tables graphs

Answer 1 · 2017-03-24T18:59:11Z

Matthew Gillespie answered Mar 24, '17 Pieter Cecat commented Mar 24, '17

Here is a script you can run:

treenode table1 = reftable("GlobalTable1");
treenode table2 = reftable("GlobalTable2");
treenode table3 = reftable("GlobalTable3");

for(int i = 1; i <= gettablerows(table1); i++){
	for(int j = 1; j <= gettablecols(table1); j++){
		int value = gettablenum(table1, i, j) * gettablenum(table2, i, j);
		settablenum(table3, i, j, value);
	}
}

If you only want to do the first row change i <= gettablerows(table1) to i <= 1.

If you upgrade to 17.0 you can use dot syntax:

Table table1 = reftable("GlobalTable1");
Table table2 = reftable("GlobalTable2");
Table table3 = reftable("GlobalTable3");

for(int i = 1; i <= table1.numRows; i++){
	for(int j = 1; j <= table1.numCols; j++){
		table3[i][j] = table1[i][j] * table2[i][j];
	}
}

· 3

Pieter Cecat commented · Mar 24, 2017 at 07:09 PM

Is it possible to run the script automatically everytime I run the model?

0 ·

Matthew Gillespie ♦♦ Pieter Cecat commented · Mar 24, 2017 at 07:15 PM

You could put the code in an OnReset or OnRunStart trigger (Toolbox >Add > Modelling Logic > Model Trigger)

2 ·

Pieter Cecat commented · Mar 24, 2017 at 07:16 PM

Nevermind I already found it:

A FlexSim model has an On Run Stop. Here I put the logic.

Thanks

0 ·

question