Hello,
I am trying to use a calculated table to consolidate the data from a transaction table.
Transaction Table
Seq Model StayTime
1 A 1
1 B 2
2 A 3
I basically want to consolidate the above table into following
Seq A B
1 1 2
2 3
For that I tried to write a SQL Query using PIVOT command which are not working.
Can any one help me with a sql commend for the same.
Thanks,
Praneeth.
SQL is a kind of interface. It doesn't support the whole library clauses. As a start what you can use, please look into the manual and the reference. At the end you find a list of supported clauses. If the clause "PIVOT" is there on the list, you can use the clause otherwise not.
We don't support the PIVOT clause in FlexSim's SQL. You will need to reference the help manual for the list of clauses we do support. In 2018 Update 1, this topic is in the Help Manual under:
The SQL Queries topic has a section called SQL Language Support, where all supported clauses are listed.
In order to get the table you want, you will probably need to write a FlexScript function that reads the first table to produce the second.
7 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.
