<?xml version="1.0" encoding="UTF-8"?>
<talendfile:ProcessType xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.talend.org/mapper" xmlns:talendfile="platform:/resource/org.talend.model/model/TalendFile.xsd" defaultContext="Default">
<context confirmationNeeded="false" name="Default"/>
<parameters><elementParameter field="TEXT" name="JOB_RUN_VM_ARGUMENTS" value=" -Xms256M -Xmx1024M"/><elementParameter field="CHECK" name="JOB_RUN_VM_ARGUMENTS_OPTION" value="false"/></parameters>
<node componentName="tFileInputDelimited" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="160" posY="96">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileInputDelimited_1"/><elementParameter field="FILE" name="FILENAME" value="&quot;/var/tmp/battle/data/orders.csv&quot;"/><elementParameter field="TEXT" name="ROWSEPARATOR" value="&quot;\n&quot;"/><elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;,&quot;"/><elementParameter field="TEXT" name="HEADER" value="1"/><elementParameter field="TEXT" name="FOOTER" value="0"/><elementParameter field="TEXT" name="LIMIT" value=""/>
<elementParameter field="CHECK" name="CSV_OPTION" value="false"/><elementParameter field="CHECK" name="REMOVE_EMPTY_ROW" value="true"/><elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/><elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;UTF-8&quot;"/><elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="UTF-8"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" name="tFileInputDelimited_1"><column comment="" key="false" length="-1" name="order_id" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="customer_id" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="order_date" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="status" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="amount" nullable="true" pattern="" precision="-1" sourceType="" type="id_BigDecimal" usefulColumn="true"/></metadata></node>
<node componentName="tFileInputDelimited" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="352" posY="256">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileInputDelimited_2"/><elementParameter field="FILE" name="FILENAME" value="&quot;/var/tmp/battle/data/customers.csv&quot;"/><elementParameter field="TEXT" name="ROWSEPARATOR" value="&quot;\n&quot;"/><elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;,&quot;"/><elementParameter field="TEXT" name="HEADER" value="1"/><elementParameter field="TEXT" name="FOOTER" value="0"/><elementParameter field="TEXT" name="LIMIT" value=""/>
<elementParameter field="CHECK" name="CSV_OPTION" value="false"/><elementParameter field="CHECK" name="REMOVE_EMPTY_ROW" value="true"/><elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/><elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;UTF-8&quot;"/><elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="UTF-8"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" name="tFileInputDelimited_2"><column comment="" key="false" length="-1" name="customer_id" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="name" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="country" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/></metadata></node>
<node componentName="tMap" componentVersion="2.1" offsetLabelX="0" offsetLabelY="0" posX="352" posY="96">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tMap_1"/><elementParameter field="EXTERNAL" name="MAP" value=""/><elementParameter field="CLOSED_LIST" name="LINK_STYLE" value="AUTO"/><elementParameter field="DIRECTORY" name="TEMPORARY_DATA_DIRECTORY" value=""/><elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/><elementParameter field="CHECK" name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" label="paid" name="paid"><column comment="" key="false" length="-1" name="country" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="month" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="order_id" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="amount" nullable="true" pattern="" precision="-1" sourceType="" type="id_BigDecimal" usefulColumn="true"/></metadata>
<nodeData xsi:type="MapperData"><uiProperties/><varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
<outputTables sizeState="INTERMEDIATE" name="paid" expressionFilter="&quot;paid&quot;.equals(orders.status)" activateExpressionFilter="true">
<mapperTableEntries name="country" expression="customers.country" type="id_String" nullable="true"/>
<mapperTableEntries name="month" expression="orders.order_date.substring(0, 7)" type="id_String" nullable="true"/>
<mapperTableEntries name="order_id" expression="orders.order_id" type="id_Integer" nullable="true"/>
<mapperTableEntries name="amount" expression="orders.amount" type="id_BigDecimal" nullable="true"/>
</outputTables>
<inputTables sizeState="INTERMEDIATE" name="orders" matchingMode="UNIQUE_MATCH" lookupMode="LOAD_ONCE"><mapperTableEntries name="order_id" type="id_Integer" nullable="true"/><mapperTableEntries name="customer_id" type="id_Integer" nullable="true"/><mapperTableEntries name="order_date" type="id_String" nullable="true"/><mapperTableEntries name="status" type="id_String" nullable="true"/><mapperTableEntries name="amount" type="id_BigDecimal" nullable="true"/></inputTables>
<inputTables sizeState="INTERMEDIATE" name="customers" matchingMode="UNIQUE_MATCH" lookupMode="LOAD_ONCE" innerJoin="true">
<mapperTableEntries name="customer_id" expression="orders.customer_id" type="id_Integer" nullable="true"/>
<mapperTableEntries name="name" type="id_String" nullable="true"/><mapperTableEntries name="country" type="id_String" nullable="true"/></inputTables>
</nodeData></node><node componentName="tAggregateRow" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="544" posY="96">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tAggregateRow_1"/>
<elementParameter field="TABLE" name="GROUPBYS"><elementValue elementRef="OUTPUT_COLUMN" value="country"/><elementValue elementRef="INPUT_COLUMN" value="country"/><elementValue elementRef="OUTPUT_COLUMN" value="month"/><elementValue elementRef="INPUT_COLUMN" value="month"/></elementParameter>
<elementParameter field="TABLE" name="OPERATIONS"><elementValue elementRef="OUTPUT_COLUMN" value="orders"/><elementValue elementRef="FUNCTION" value="count"/><elementValue elementRef="INPUT_COLUMN" value="order_id"/><elementValue elementRef="IGNORE_NULL" value="false"/><elementValue elementRef="OUTPUT_COLUMN" value="revenue"/><elementValue elementRef="FUNCTION" value="sum"/><elementValue elementRef="INPUT_COLUMN" value="amount"/><elementValue elementRef="IGNORE_NULL" value="false"/></elementParameter>
<elementParameter field="CHECK" name="USE_FINANCIAL_PRECISION" value="true"/><elementParameter field="CHECK" name="CHECK_TYPE_OVERFLOW" value="false"/><elementParameter field="CHECK" name="CHECK_ULP" value="false"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" name="tAggregateRow_1"><column comment="" key="false" length="-1" name="country" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="month" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="orders" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="revenue" nullable="true" pattern="" precision="-1" sourceType="" type="id_BigDecimal" usefulColumn="true"/></metadata></node><node componentName="tSortRow" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="736" posY="96">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tSortRow_1"/>
<elementParameter field="TABLE" name="CRITERIA"><elementValue elementRef="COLNAME" value="country"/><elementValue elementRef="SORT" value="alpha"/><elementValue elementRef="ORDER" value="asc"/><elementValue elementRef="COLNAME" value="month"/><elementValue elementRef="SORT" value="alpha"/><elementValue elementRef="ORDER" value="asc"/></elementParameter>
<elementParameter field="CHECK" name="EXTERNAL" value="false"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" name="tSortRow_1"><column comment="" key="false" length="-1" name="country" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="month" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="orders" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="revenue" nullable="true" pattern="" precision="-1" sourceType="" type="id_BigDecimal" usefulColumn="true"/></metadata></node><node componentName="tFileOutputDelimited" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="928" posY="96">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileOutputDelimited_1"/><elementParameter field="FILE" name="FILENAME" value="&quot;/var/tmp/battle/out/talend_result.csv&quot;"/><elementParameter field="TEXT" name="ROWSEPARATOR" value="&quot;\n&quot;"/><elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;,&quot;"/><elementParameter field="CHECK" name="APPEND" value="false"/><elementParameter field="CHECK" name="INCLUDEHEADER" value="true"/><elementParameter field="CHECK" name="CREATE" value="true"/>
<elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;UTF-8&quot;"/><elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="UTF-8"/><elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
<metadata connector="FLOW" name="tFileOutputDelimited_1"><column comment="" key="false" length="-1" name="country" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="month" nullable="true" pattern="" precision="-1" sourceType="" type="id_String" usefulColumn="true"/><column comment="" key="false" length="-1" name="orders" nullable="true" pattern="" precision="-1" sourceType="" type="id_Integer" usefulColumn="true"/><column comment="" key="false" length="-1" name="revenue" nullable="true" pattern="" precision="-1" sourceType="" type="id_BigDecimal" usefulColumn="true"/></metadata></node>
<connection connectorName="FLOW" label="orders" lineStyle="0" metaname="tFileInputDelimited_1" offsetLabelX="0" offsetLabelY="0" source="tFileInputDelimited_1" target="tMap_1"><elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/><elementParameter field="TEXT" name="UNIQUE_NAME" value="orders"/></connection><connection connectorName="FLOW" label="customers" lineStyle="8" metaname="tFileInputDelimited_2" offsetLabelX="0" offsetLabelY="0" source="tFileInputDelimited_2" target="tMap_1"><elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/><elementParameter field="TEXT" name="UNIQUE_NAME" value="customers"/></connection><connection connectorName="FLOW" label="paid" lineStyle="0" metaname="paid" offsetLabelX="0" offsetLabelY="0" source="tMap_1" target="tAggregateRow_1"><elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/><elementParameter field="TEXT" name="UNIQUE_NAME" value="paid"/></connection><connection connectorName="FLOW" label="aggregated" lineStyle="0" metaname="tAggregateRow_1" offsetLabelX="0" offsetLabelY="0" source="tAggregateRow_1" target="tSortRow_1"><elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/><elementParameter field="TEXT" name="UNIQUE_NAME" value="aggregated"/></connection><connection connectorName="FLOW" label="sorted" lineStyle="0" metaname="tSortRow_1" offsetLabelX="0" offsetLabelY="0" source="tSortRow_1" target="tFileOutputDelimited_1"><elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/><elementParameter field="TEXT" name="UNIQUE_NAME" value="sorted"/></connection>
<subjob><elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileInputDelimited_1"/></subjob>
</talendfile:ProcessType>