Problems trying to create new rows for each new label value...

Question

question

Ruben M4 asked Jul 12, '21 Ruben M4 commented Jul 13, '21

Problems trying to create new rows for each new label value...

global table question.fsmI would like that for each new value of the label "destination_deliveryDate" a row is created to make a counter of the times that the values of this label are repeated. I have tried to do it the way you can see in the image and in the attached file.

Software Version:

FlexSim 19.2.4

global tables write to global table

screenshot-4.png (38.1 KiB)

global-table-question.fsm (27.2 KiB)

· 1

Joerg Vogel commented · Jul 12, 2021 at 09:34 AM

It is currently not so easy to find, but in triggers there is a picklist template that does exactly what you try. This templates append a new line for each event to a global table and write a value in this new cell. Perhaps you can learn from the default source code there.

0 ·

Answer 1 · 2021-07-12T09:58:54Z

Roi Sánchez answered Jul 12, '21 Ruben M4 commented Jul 13, '21

Hi @Ruben M4 , replace your code inside your Custom Code activity to this new one:

Table table = Table("GlobalTable1");
string row = token.destination_deliveryDate;
string col = "Col 1";

int aux = 0;

if (table.numRows > 0){
int i;
for(i=1; i<=table.numRows; i++){
if (table.getRowHeader(i) == row){
table[row][col]++;
aux = 1;
}
}
if (aux == 0){
table.addRow();
table.setRowHeader(table.numRows, row);
table[row][col] = 1;
}
}
else{
table.addRow();
table.setRowHeader(table.numRows, row);
table[row][col] = 1;
}

I basically check for every row in the table if its rowName header is the same as the current label of the token running the code. If not, I create a new row.

Remember to delete all Rows in the table in the Reset trigger to prevent it from overlapping its data.

· 1

Ruben M4 commented · Jul 13, 2021 at 09:03 AM

Thank you so much. It runs perfectly.

0 ·

question