Group by

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Group by</name>
     <script>pivot_data_set</script>
     <allow>EXTRACT_LOAD</allow>
     <sources>
          <source noconnection="true">
               <name>data_set</name>
               <extract>
                  <reader class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector" filename="{app.root.data}/demo/gre_toefl_scores.xlsx" sheetname="scores" />
               </extract>
               <tasks>
                    
                    <task noconnection="true">
                         <name>pivot</name>
                         <class>com.toolsverse.etl.core.task.common.Pivot</class>
                         <variables>
                              <KEYS value="EMPLID,TEST_ID"/>
                              <FIELDS value="student=EMPLID;test=TEST_ID;total_score=sum(SCORE);
                                             avg_score=avg(SCORE);max_score=max(SCORE);min_score=min(SCORE);taken=count(SCORE);" />
                         </variables>
                    </task>
               </tasks>
          </source>
     </sources>
     <destinations>
          <destination noconnection="true">
               <name>data_set</name>
               <load>
                   <writer class="com.toolsverse.etl.connector.excel.ExcelXlsxConnector" filename="{app.root.data}\demo\matrix-output.xlsx" sheetname="output" />
               </load>
          </destination>
     </destinations>
</scenario>