Cognos except

<report xmlns="http://developer.cognos.com/schemas/report/15.5/" useStyleVersion="11.6" expressionLocale="en-us">
    <drillBehavior/>
    <layouts>
        <layout>
            <reportPages>
                <page name="Page1">
                    <style>
                        <defaultStyles>
                            <defaultStyle refStyle="pg"/>
                        </defaultStyles>
                    </style>
                    <pageBody>
                        <style>
                            <defaultStyles>
                                <defaultStyle refStyle="pb"/>
                            </defaultStyles>
                        </style>
                        <contents>
                            <table>
                                <style>
                                    <defaultStyles>
                                        <defaultStyle refStyle="tb"/>
                                    </defaultStyles>
                                    <CSS value="border-collapse:collapse"/>
                                </style>
                                <tableRows>
                                    <tableRow>
                                        <tableCells>
                                            <tableCell>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <staticValue>Input</staticValue>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                            <tableCell>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <staticValue>Output</staticValue>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                            <tableCell>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <staticValue>Desired Output</staticValue>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                        </tableCells>
                                    </tableRow>
                                    <tableRow>
                                        <tableCells>
                                            <tableCell>
                                                <contents>
                                                    <list horizontalPagination="true" refQuery="input" name="List1">
                                                        <noDataHandler>
                                                            <contents>
                                                                <block>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <staticValue>No Data Available</staticValue>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                    <style>
                                                                        <CSS value="padding:16px;"/>
                                                                    </style>
                                                                </block>
                                                            </contents>
                                                        </noDataHandler>
                                                        <style>
                                                            <CSS value="border-collapse:collapse"/>
                                                            <defaultStyles>
                                                                <defaultStyle refStyle="ls"/>
                                                            </defaultStyles>
                                                        </style>
                                                        <listColumns>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                        </listColumns>
                                                        <sortList>
                                                            <sortItem refDataItem="Column1"/>
                                                            <sortItem refDataItem="Column2"/>
                                                        </sortList>
                                                    </list>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                            <tableCell>
                                                <contents>
                                                    <list horizontalPagination="true" refQuery="output" name="List3">
                                                        <noDataHandler>
                                                            <contents>
                                                                <block>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <staticValue>No Data Available</staticValue>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                    <style>
                                                                        <CSS value="padding:16px;"/>
                                                                    </style>
                                                                </block>
                                                            </contents>
                                                        </noDataHandler>
                                                        <style>
                                                            <CSS value="border-collapse:collapse"/>
                                                            <defaultStyles>
                                                                <defaultStyle refStyle="ls"/>
                                                            </defaultStyles>
                                                        </style>
                                                        <listColumns>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                        </listColumns>
                                                        <sortList>
                                                            <sortItem refDataItem="Column2"/>
                                                        </sortList>
                                                    </list>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                            <tableCell>
                                                <contents>
                                                    <list horizontalPagination="true" refQuery="desiredOutput" name="List2">
                                                        <noDataHandler>
                                                            <contents>
                                                                <block>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <staticValue>No Data Available</staticValue>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                    <style>
                                                                        <CSS value="padding:16px;"/>
                                                                    </style>
                                                                </block>
                                                            </contents>
                                                        </noDataHandler>
                                                        <style>
                                                            <CSS value="border-collapse:collapse"/>
                                                            <defaultStyles>
                                                                <defaultStyle refStyle="ls"/>
                                                            </defaultStyles>
                                                        </style>
                                                        <listColumns>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column1"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                            <listColumn>
                                                                <listColumnTitle>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lt"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemLabel refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnTitle>
                                                                <listColumnBody>
                                                                    <style>
                                                                        <defaultStyles>
                                                                            <defaultStyle refStyle="lm"/>
                                                                        </defaultStyles>
                                                                    </style>
                                                                    <contents>
                                                                        <textItem>
                                                                            <dataSource>
                                                                                <dataItemValue refDataItem="Column2"/>
                                                                            </dataSource>
                                                                        </textItem>
                                                                    </contents>
                                                                </listColumnBody>
                                                            </listColumn>
                                                        </listColumns>
                                                        <sortList>
                                                            <sortItem refDataItem="Column2"/>
                                                        </sortList>
                                                    </list>
                                                </contents>
                                                <style>
                                                    <CSS value="vertical-align:top;text-align:left;border:1pt solid silver"/>
                                                </style>
                                            </tableCell>
                                        </tableCells>
                                    </tableRow>
                                </tableRows>
                            </table>
                        </contents>
                    </pageBody>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_legacyDrillDown" value="0"/>
                    </XMLAttributes>
                </page>
            </reportPages>
        </layout>
    </layouts>
    <XMLAttributes>
        <XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/>
        <XMLAttribute output="no" name="listSeparator" value=","/>
        <XMLAttribute output="no" name="decimalSeparator" value="."/>
        <XMLAttribute output="no" name="RS_modelModificationTime" value="2015-11-25T21:38:24.820Z"/>
    </XMLAttributes>
    <queries>
        <query name="input">
            <source>
                <sqlQuery name="SQL1" dataSource="great_outdoors_sales">
                    <sqlText>select *
  from (
    values
        (111, &apos;A&apos;)
      , (111, &apos;B&apos;)
      , (111, &apos;C&apos;)
      , (222, &apos;B&apos;)
      , (222, &apos;C&apos;)
      , (333, &apos;A&apos;)
      , (333, &apos;C&apos;)
    ) q (Column1, Column2)</sqlText>
                    <mdProjectedItems>
                        <mdProjectedItem name="Column1"/>
                        <mdProjectedItem name="Column2"/>
                    </mdProjectedItems>
                </sqlQuery>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[SQL1].[Column1]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="1"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
                <dataItem name="Column2">
                    <expression>[SQL1].[Column2]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="3"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
            </selection>
        </query>
        <query name="desiredOutput">
            <source>
                <sqlQuery name="SQL2" dataSource="great_outdoors_sales">
                    <sqlText>  select *
  from (
    values
      (333, &apos;A&apos;)
    , (333, &apos;C&apos;)
    ) q (Column1, Column2)</sqlText>
                    <mdProjectedItems>
                        <mdProjectedItem name="Column1"/>
                        <mdProjectedItem name="Column2"/>
                    </mdProjectedItems>
                </sqlQuery>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[SQL2].[Column1]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="1"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
                <dataItem name="Column2">
                    <expression>[SQL2].[Column2]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="3"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
            </selection>
        </query>
        <query name="allColumn1">
            <source>
                <queryRef refQuery="input"/>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[input].[Column1]</expression>
                </dataItem>
            </selection>
        </query>
        <query name="BColumn1">
            <source>
                <queryRef refQuery="input"/>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[input].[Column1]</expression>
                </dataItem>
            </selection>
            <detailFilters>
                <detailFilter>
                    <filterExpression>[input].[Column2] = &apos;B&apos;</filterExpression>
                </detailFilter>
            </detailFilters>
        </query>
        <query name="filtered">
            <source>
                <queryOperation name="Except1" setOperation="EXCEPT">
                    <queryRefs>
                        <queryRef refQuery="allColumn1"/>
                        <queryRef refQuery="BColumn1"/>
                    </queryRefs>
                    <projectionList autoGenerated="true">
                        <queryItem name="Column1"/>
                    </projectionList>
                </queryOperation>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[Except1].[Column1]</expression>
                </dataItem>
            </selection>
        </query>
        <query name="output">
            <source>
                <joinOperation>
                    <joinOperands>
                        <joinOperand cardinality="1:1">
                            <queryRef refQuery="input"/>
                        </joinOperand>
                        <joinOperand cardinality="1:1">
                            <queryRef refQuery="filtered"/>
                        </joinOperand>
                    </joinOperands>
                    <joinFilter>
                        <filterExpression>[input].[Column1] = [filtered].[Column1]</filterExpression>
                    </joinFilter>
                </joinOperation>
            </source>
            <selection>
                <dataItem name="Column1">
                    <expression>[input].[Column1]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="1"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
                <dataItem name="Column2">
                    <expression>[input].[Column2]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="3"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value=""/>
                    </XMLAttributes>
                </dataItem>
            </selection>
        </query>
    </queries>
    <modelPath>/content/folder[@name=&apos;Samples&apos;]/folder[@name=&apos;Models&apos;]/package[@name=&apos;GO sales (query)&apos;]/model[@name=&apos;model&apos;]</modelPath>
</report>