("SELECT SUM(NoOfVehical) FROM MyTable WHERE [City] == 'Delhi') this query is not working for getting the total vehicles in city. Table as under:
| City | TypeOfVehical | NoOfVehical |
| Delhi | Sedan | |
| Mumbai | Sedan | |
| Chennai | Sedan | |
| Kolkata | Sedan | |
| Bengaluru | Sedan | |
| Chennai | Hatchback | |
| Kolkata | Hatchback | |
| Bengaluru | Hatchback | |
| Delhi | Hatchback | |
| Mumbai | Hatchback | |
| Delhi | SUV | |
| Mumbai | SUV | |
| Chennai | SUV | |
| Kolkata | SUV | |
| Bengaluru | SUV | |
| Chennai | Truck | |
| Kolkata | Truck | |
| Bengaluru | Truck | |
| Delhi | Truck | |
| Mumbai | Truck |
I could not replicate the issue. Here is a model that worked for me. Run the script in the script window to test the query.
I did find one bug in that, if your column name starts with Number value it throws error, we should have column name starting with Text. e.g. "1_City" will throw error while "City" will execute the code.
It is working in the model that you shared, but for me its not working. I dont know the reason :(
9 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.
