Diff datasets

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Diff datasets</name>
     <script>diff</script>
     <allow>EXTRACT_LOAD</allow>
     <sources>
          <source noconnection="true">
               <name>data_set_1</name>
               <extract>
                    <reader
                         class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector"
                         filename="{app.root.data}\demo\matrix.xlsx" sheetname="norm"/>
               </extract>
          </source>
          <source noconnection="true">
               <name>data_set_2</name>
               <extract>
                    <reader
                         class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector"
                         filename="{app.root.data}\demo\matrix.xlsx" sheetname="norm2"/>
               </extract>
          </source>
          <source noconnection="true">
               <name>data_set_only1</name>
               <tasks>
                    <task noconnection="true">
                         <name>minus</name>
                         <class>com.toolsverse.etl.core.task.common.Minus</class>
                         <variables>
                              <DRIVING value="data_set_1"/>
                              <MINUS value="data_set_2"/>
                         </variables>
                    </task>
                    <task noconnection="true">
                         <name>add_column</name>
                         <class>com.toolsverse.etl.core.task.common.Pivot</class>
                         <variables>
                              <FIELDS value="dataset='first only'; first=first; last=last; course=course; year=year; address=address;"/>
                         </variables>
                    </task>
               </tasks>
          </source>
          <source noconnection="true">
               <name>data_set_only2</name>
               <tasks>
                    <task noconnection="true">
                         <name>minus</name>
                         <class>com.toolsverse.etl.core.task.common.Minus</class>
                         <variables>
                              <DRIVING value="data_set_2"/>
                              <MINUS value="data_set_1"/>
                         </variables>
                    </task>
                    <task noconnection="true">
                         <name>add_column</name>
                         <class>com.toolsverse.etl.core.task.common.Pivot</class>
                         <variables>
                              <FIELDS value="dataset='second only'; first=first; last=last; course=course; year=year; address=address;"/>
                         </variables>
                    </task>
               </tasks>
          </source>

<source noconnection="true">
               <name>data_set_12</name>
               <tasks>
                    <task noconnection="true">
                         <name>intersect</name>
                         <class>com.toolsverse.etl.core.task.common.Intersect</class>
                         <variables>
                              <DRIVING value="data_set_2"/>
                              <INTERSECT value="data_set_1"/>
                         </variables>
                    </task>
                    <task noconnection="true">
                         <name>add_column</name>
                         <class>com.toolsverse.etl.core.task.common.Pivot</class>
                         <variables>
                              <FIELDS value="dataset='both'; first=first; last=last; course=course; year=year; address=address;"/>
                         </variables>
                    </task>
               </tasks>
          </source>

<source noconnection="true">
               <name>first_and_second</name>
               <tasks>
                    <task noconnection="true" scope="after">
                         <name>union</name>
                         <class>com.toolsverse.etl.core.task.common.Union</class>
                         <variables>
                              <DRIVING value="DATA_SET_ONLY1"/>
                              <UNION value="DATA_SET_ONLY2"/>
                              <TYPE value="union all"/>
                         </variables>
                    </task>
               </tasks>
          </source>

<source noconnection="true">
               <name>first_second_both</name>
               <tasks>
                    <task noconnection="true" scope="after">
                         <name>union</name>
                         <class>com.toolsverse.etl.core.task.common.Union</class>
                         <variables>
                              <DRIVING value="FIRST_AND_SECOND"/>
                              <UNION value="DATA_SET_12"/>
                              <TYPE value="union all"/>
                         </variables>
                    </task>
               </tasks>
          </source>
          
     </sources>
     <destinations>
          <destination noconnection="true">
               <name>RESULT</name>
               <source>FIRST_SECOND_BOTH</source>
               <load>
                    <driver name="com.toolsverse.etl.driver.GenericFileDriver"/>
                    <writer
                         class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector"
                         filename="{app.root.data}\demo\matrix-output.xlsx" sheetname="output"/>
               </load>
          </destination>
     </destinations>
</scenario>