Hey need example how i can get a max value from a join table where only several row should be showed.
I tried to create this one :
Table result2 = Table.query("SELECT MAX(tabel1.[Line] FROM table1,table2\
WHERE table2.[Package] = table1.[Package ID]");
got error said : exception: FlexScript exception: Could not parse query
Where table 2 is actually a query table without being dump/clone to global table
For a start you have a missing close parenthesis for the MAX function but also where are you passing in the reference to table2 ? It should be the first parameter referenced as $1 I think - and you may need to dump/clone it if it isn't already.
If those tips don't help, post your model or just the parts relevant to this question, and we'll take look
Hi @Ranggi M,
We haven't heard back from you. 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.
14 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
