Table header: check if header exists

Question

question

Tomi Kosunen asked Sep 14, '22 Jason Lightfoot edited Sep 14, '22

Table header: check if header exists

Hi

Is it possible to check, if table has some specific column/row header name? Eg. check if table has row header "Products" (Table("MyTable")["Products"][1]). Something else than looping thru the whole table.

Software Version:

FlexSim 22.2.1

tables

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2022-09-14T13:51:32Z

Jason Lightfoot answered Sep 14, '22 Jason Lightfoot edited Sep 14, '22

string colheader="Col 3";
treenode data=reftable("GlobalTable1");
if (data.dataType==DATATYPE_BUNDLE)
return getbundlefieldnr(data,colheader)>-1;
if (data.subnodes.length)
    return objectexists(data.first.subnodes[colheader]);

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question