Revision history [back]

I am using DB Browser for SQLite to read the eplusout.sql. I am having trouble with End Uses By Subcategory table. It does not appear as I would like it to appear.

Here is what I have tried:

Select ColumnName as "Utility", Rowname as "End Use", Value as "Subcategory", Units

from TabularDataWithStrings WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"

and TableName = "End Uses By Subcategory"

Can anyone suggest any edits to the above query or if the information exists elsewhere and two tables need to be joined.

I am using DB Browser for SQLite to read the eplusout.sql. I am having trouble with End Uses By Subcategory table. It does not appear as I would like it to appear.

Here is what I have tried:

Select ColumnName as "Utility", Rowname as "End Use", Value as "Subcategory",   Units
 
Units
from TabularDataWithStrings WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"
 
"AnnualBuildingUtilityPerformanceSummary"
and TableName = "End Uses By Subcategory"Subcategory"

I am using DB Browser for SQLite to read the eplusout.sql. I am having trouble with End Uses By Subcategory table. It does not appear as I would like it to appear.

Here is what I have tried:

Select ColumnName as "Utility", Rowname as "End Use", Value as "Subcategory",   Units
from TabularDataWithStrings WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"
and TableName = "End Uses By Subcategory"

Can anyone suggest any edits to the above query or if the information exists elsewhere and two tables need to be joined.

I am using DB Browser for SQLite to read the eplusout.sql. I am having trouble with End Uses By Subcategory table. It does not appear as I would like it to appear.

Here is what I have tried:

Select ColumnName as "Utility", Rowname as "End Use", Value as "Subcategory",   Units
from TabularDataWithStrings WHERE ReportName = "AnnualBuildingUtilityPerformanceSummary"
and TableName = "End Uses By Subcategory"

Can anyone suggest any edits to the above query or if the information exists elsewhere and two tables need to be joined.