Join Data Sets

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Join data sets</name>
     <script>join_data_set</script>
     <allow>EXTRACT_LOAD</allow>
     <variables>
          <JOIN_TYPE label="Join Type" value="inner" >
             <item type="select" default="inner">
                <select> 
                   <value key="inner" description="inner" />
                   <value key="outer" description="outer" />
                </select>
             </item>
         </JOIN_TYPE>
     </variables>
     <sources>
          <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="join" />
               </extract>
          </source>
          <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="combine" />
               </extract>
               <tasks>
                    
                    <task noconnection="true">
                         <name>join</name>
                         <class>com.toolsverse.etl.core.task.common.Join</class>
                         <variables>
                              <JOIN value="data_set_2"/>
                              <TYPE value="{JOIN_TYPE}"/>
                              <KEYS value="first,last"/>
                              <EXCLUDE value="addr1" />
                         </variables>
                    </task>
               </tasks>
          </source>
     </sources>
     <destinations>
          <destination noconnection="true">
               <name>data_set_1</name>
               <load>
                   <writer class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector" filename="{app.root.data}\demo\matrix-output.xlsx" sheetname="output" />
               </load>
          </destination>
     </destinations>
</scenario>