I have a global table with bunch of columns and quite a few rows. I want to create a map from those. How can I do it in flexscript?
How to add all values from global table to a map variable?
FlexSim 23.0.15
Below you can find the code for a user command - mapFromTable() - where you pass in the table and optionally columns you want to use as your map keys.
For example, with this data:
running
Map m=mapFromTable("GlobalTable1",["Name","Height"]);
return m[["Bob",175]].Zip;
will return 1234 - the shorter Bob's zip code;
The user command is:
Variant v=param(1);
Variant k=param(2);
Table t;
switch (v.type) {
case VAR_TYPE_STRING:
case VAR_TYPE_NODE: t=Table(v);break;
default: msg("mapFromTable()", "Table type is "+v.type,1); return 0;
}
Array keys=[t.getColHeader(1)];
if (parqty>1)
keys=param(2);
Array attrCols=[];
for (int n=t.numCols;n>0;n--){
if (keys.indexOf(n)<0 && keys.indexOf(t.getColHeader(n))<0)
attrCols.push(t.getColHeader(n));
}
Map m;
Map attrs;
for (int r=t.numRows;r>0;r--){
Array rowKey=[];
for (int k=1;k<=keys.length;k++)
rowKey.push(t[r][keys[k]]);
for (int n=attrCols.length;n>0;n--) {
attrs[attrCols[n]]=t[r][attrCols[n]];
}
m[rowKey]=attrs.clone();
attrs.clear();
}
return m.clone();
Model and auto-installing library attached.
16 People are following this question.
