SQL Query for Conditional Sum

Question

question

Aaditya J asked Oct 18, '18 Aaditya J answered Oct 18, '18

SQL Query for Conditional Sum

("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

Software Version:

FlexSim 18.2.0

query sql query conditional

· 1

Aaditya J commented · Oct 18, 2018 at 04:15 PM

Add any number of cars in last table, I dont know why the numbers are not visible

0 ·

Answer 1 · 2018-10-18T16:42:17Z

Jordan Johnson answered Oct 18, '18

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.

workingquery.fsm

workingquery.fsm (16.7 KiB)

Answer 2 · 2018-10-18T18:03:54Z

Aaditya J answered Oct 18, '18

It is working in the model that you shared, but for me its not working. I dont know the reason :(

Answer 3 · 2018-10-18T18:38:13Z

Aaditya J answered Oct 18, '18

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.

question