topic Re: How to check if a Column in a Global Table exist? in FlexSim Forum

How to check if a Column in a Global Table exist?

manuel_s4 — Fri, 28 Feb 2020 17:22:11 GMT

[ FlexSim 19.1.0 ]

I want to check if a column in a global table with a certain name exists, if not create that column.

Thanks,

Manuel.

Re: How to check if a Column in a Global Table exist?

tanner_p — Fri, 28 Feb 2020 20:31:52 GMT

Hi @Manuel Sinco,

I used the getColHeader() function to parse through the column header values to match to a desired name. If the name is not in any of the columns, a new column with the desired name is added. Here's a model with the code you can test. Simply press Play on the Script and watch it add "Col 5" to GlobalTable1.

column-value-lookup.fsm

Re: How to check if a Column in a Global Table exist?

manuel_s4 — Fri, 28 Feb 2020 21:54:28 GMT

Thanks Tanner, I thought about it before posting the question. I was thinking about a command referring maybe to the tree to assert something, but if it does not exist is okay.

I accept the answer based on that someone can use it.

Thank you.