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

Question

question

Manuel Sinco asked Feb 28, '20 Manuel Sinco commented Feb 28, '20

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

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

Thanks,

Manuel.

Software Version:

FlexSim 19.1.0

column exist

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 · 2020-02-28T20:31:52Z

tannerp answered Feb 28, '20 Manuel Sinco commented Feb 28, '20

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

column-value-found.png (27.0 KiB)

column-value-lookup.fsm (24.0 KiB)

· 1

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.

Manuel Sinco commented · Feb 28, 2020 at 09:54 PM

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.

0 ·

question