question

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.

mapFromTable.fsm

mapFromTable.fsl