Hello, I'm having trouble making a SQL filter in a Globaltable and pulling the first result from it, I've tried several syntaxes and nothing works, would anyone know how to help me?
EX: Table.query("SELECT col1 FROM Globaltable1")[1][1]
How to make a SQL filter in a Global Table and capture the first result?
FlexSim 23.0.0
There's a space in the default global table's column headings so if you've not renamed them you need:
Table.query("SELECT [Col 1] FROM GlobalTable1")[1][1]
that's not the problem, the column name I left generic in my question only, but thanks for the answer
What is the problem then? Since the syntax I provided is correct you will have to provide your model and point us to the offending lines of code.
15 People are following this question.
