question

Amy avatar image
0 Likes"
Amy asked Jeanette F commented

Query syntax Error in CalculatedTable

I want to run 30 models without changing variables and store the generated PersonMilestone and PersonLabel locally. After running the experiment in the Experimenter, I want to save the data using this SQL query from the CalculatedTable:

SELECT *
FROM [Experiment.PersonMilestones] AS Milestones
INNER JOIN [Experiment.PersonLabels] AS Labels
ON Milestones.PID = Labels.PID;

However, I'm encountering an error with this query.

I would appreciate any assistance you can provide.

FlexSim 21.2.4
sql query
· 1
5 |100000

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

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Amy ,

Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·

0 Answers