<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="66"/>
        <last_saved_by value="Prashant_Maheshwari_using_Easy_Data_Transform_v1_44_0_on_macOS_13_5_at_2023_11_14_18_39_19"/>
        <locale value="en_IN"/>
        <id value="7403050d327707000a727601020b38"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Fprashant%2FDownloads%2FEDT%20Forum%2FHow%20to%20Subtotoal.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="102" custom_delimiter="%2A" ignore_repeated_delim="0" text="Company%09Sales%20Qty%09Sales%20Amt%09Order%20in%20Hand%20Qty%09Order%20in%20Hand%20Amt%09Total%20Qty%09Total%20Amount%09Company%0D%0AApple%2CLocal%099200%092189%097839%099611%091780%094218%09Apple%0D%0AApple%2CExport%091414%096733%093708%094006%092524%098984%09Apple%0D%0AMicrosoft%2CLocal%09141%095304%093639%099521%094720%098219%09Microsoft%0D%0AMicrosoft%2CExport%096971%098245%093305%09230%091676%091662%09Microsoft%0D%0AGoogle%2CLocal%09939%092332%093367%099216%09112%098234%09Google%0D%0AGoogle%2CExport%094626%092760%091879%093143%095372%09355%09Google" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="104" name="Unfill" pos="-90^74.7" pos_v12="-9074.7">
            <parameters>
                <parameter type="1" name="Columns" value="8"/>
                <parameter type="6" name="Direction" value="Down"/>
            </parameters>
        </transform>
        <transform id="105" name="New_Rows" pos="-90^194.4" pos_v12="-90194.4">
            <parameters>
                <parameter type="6" name="Number_How_Name" value="Same%20for%20every%20row"/>
                <parameter type="0" name="Number_Col_Name" value="0"/>
                <parameter type="8" name="Number_Const_Name" value="1"/>
                <parameter type="6" name="As_Name" value="User%20defined%20row%28s%29"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
                <parameter type="6" name="Location_Name" value="Below%20each%20row"/>
                <parameter type="6" name="For_Name" value="Rows%20where"/>
                <parameter type="0" name="Match_Column_Name" value="8"/>
                <parameter type="6" name="Match_Type_Name" value="%E2%88%85%20%20%20Is%20empty"/>
                <parameter type="7" name="Match_Value_Name" value=""/>
                <parameter type="5" name="Match_Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="107" name="New_Rows" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="6" name="Number_How_Name" value="Same%20for%20every%20row"/>
                <parameter type="0" name="Number_Col_Name" value="0"/>
                <parameter type="8" name="Number_Const_Name" value="0"/>
                <parameter type="6" name="As_Name" value="Blank%20row%28s%29"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
                <parameter type="6" name="Location_Name" value="Above%20each%20row"/>
                <parameter type="6" name="For_Name" value="Every%20row"/>
                <parameter type="0" name="Match_Column_Name" value="0"/>
                <parameter type="6" name="Match_Type_Name" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Match_Value_Name" value=""/>
                <parameter type="5" name="Match_Case_Sensitive" value="1"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="102" end_id="104"/>
        <connection start_id="102" end_id="107"/>
        <connection start_id="104" end_id="105"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
