[ivank]

Hi Sussane,

You need two specify two file names instead of 'Discomfort_CEN15251_CategoryII'; for example 'Discomfort_CEN15251_CategoryII_RoomEast' and 'Discomfort_CEN15251_CategoryII_RoomWest'. I would probably mention 'Cat II' in the column headers as well.

Code:

!-sqlite
! Output file name; Column headers; SQL command
RoomEast_Discomfort_CEN15251_CategoryII; RoomEast Cat II [Hours]; SELECT Value FROM TabularDataWithStrings WHERE (ReportName="AdaptiveComfortReport" AND ColumnName="CEN15251 Category II Acceptability Limits" AND RowName="PEOPLE BLOCK2:ROOMEAST")
RoomWest_Discomfort_CEN15251_CategoryII; RoomWest Cat II [Hours]; SELECT Value FROM TabularDataWithStrings WHERE (ReportName="AdaptiveComfortReport" AND ColumnName="CEN15251 Category II Acceptability Limits" AND RowName="PEOPLE BLOCK2:ROOMWEST")
!-end sqlite

You might also want to try rvx file instead of rvi (be careful to use apostrophes instead of quotation marks in sql queries).

Code:

{

    "notes" : "Some notes about this RVX",
    
    "sqls" : [
        {
            "tableName" : "RoomEast_Discomfort_CEN15251_CategoryII",
            "columnHeaders" : "RoomEast Cat II [Hours]",
            "sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (ReportName='AdaptiveComfortReport' AND ColumnName='CEN15251 Category II Acceptability Limits' AND RowName='PEOPLE BLOCK2:ROOMEAST')"
        },
        {
            tableName" : "RoomWest_Discomfort_CEN15251_CategoryII",
            "columnHeaders" : "RoomWest Cat II [Hours]",
            "sqlcommand" : "SELECT Value FROM TabularDataWithStrings WHERE (ReportName='AdaptiveComfortReport' AND ColumnName='CEN15251 Category II Acceptability Limits' AND RowName='PEOPLE BLOCK2:ROOMWEST')"
        }
    ]
}

This will give you two separate csv files with RoomEast Cat II data in one and RoomWest Cat II data in another. However, they should be merged in the 'AllCombinedResults.csv' file.

Cheers,
Ivan