<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="77"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v2_5_1_on_macOS_15_5_arm64_at_2025_05_23_19_06_41"/>
        <locale value="en_GB"/>
        <id value="7a77050a357307070b747a7409083c03"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2Fbooks%202.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^194.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="exchange%20rates.txt" schema_extra_cols="0" pos_v12="-90194.4" watching="0" medium="0" auto_fixed_widths="1" path="%2FUsers%2Folaf%2Ftmp%2Fexchange%20rates.txt" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" meta_col_name="Meta%20Info" file_type="0" id="130" alias="exchange%20rates" custom_delimiter="%2A" ignore_repeated_delim="0" meta_text="%24%28FilePath%29%20%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^-45" ignored_rows="0" show_meta="3" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="Channel_A_input.csv" schema_extra_cols="0" pos_v12="-90-45" watching="0" medium="0" auto_fixed_widths="1" path="%2FUsers%2Folaf%2Ftmp%2FChannel_A_input.csv" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" meta_col_name="Date" file_type="0" id="137" alias="Channel_A_input" custom_delimiter="%2A" ignore_repeated_delim="0" meta_text="%24%28CurrentDate%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="121" name="New_Col" pos="388.8^74.7" pos_v12="388.874.7">
            <parameters>
                <parameter type="7" name="New_Name" value="Channel"/>
                <parameter type="7" name="New_Value" value="Mega%20Distributor"/>
            </parameters>
        </transform>
        <transform id="124" name="Date_Format" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="1" name="Columns" value="6"/>
                <parameter type="7" name="Input" value="yyyy-M-d"/>
                <parameter type="7" name="Output" value="M%2Fd%2Fyyyy"/>
                <parameter type="6" name="Non_Date" value="Leave"/>
                <parameter type="7" name="User_Defined" value=""/>
            </parameters>
        </transform>
        <transform id="127" name="Remove" pos="1346.4^74.7" pos_v12="1346.474.7">
            <parameters>
                <parameter type="11" name="Columns" value="3461011"/>
            </parameters>
        </transform>
        <transform id="128" name="Reorder" pos="1825.2^74.7" pos_v12="1825.274.7">
            <parameters>
                <parameter type="4" name="Columns" value="43125"/>
            </parameters>
        </transform>
        <transform id="129" name="Rename_Cols" pos="1585.8^74.7" pos_v12="1585.874.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="ISBNSales%20Source%2ANORENAME%2A%2ANORENAME%2AAmount%20USD"/>
            </parameters>
        </transform>
        <transform id="132" name="Cross" pos="149.4^74.7" pos_v12="149.474.7">
            <parameters/>
        </transform>
        <transform id="134" name="Calculate" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="%2F%20Divide"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="5"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="8"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="135" name="Num_Format" pos="1107^74.7" pos_v12="110774.7">
            <parameters>
                <parameter type="1" name="Columns" value="11"/>
                <parameter type="6" name="Decimal_From" value="Automatic"/>
                <parameter type="6" name="Format" value="f"/>
                <parameter type="8" name="Precision" value="2"/>
                <parameter type="5" name="Group_Separator" value="0"/>
                <parameter type="6" name="Non_Numeric" value="Leave"/>
            </parameters>
        </transform>
    </transforms>
    <outputs>
        <output worksheet="Easy%20Data%20Transform" enable_output="1" pos="2064.6^74.7" delimiter="1" html_encode="1" excel_output="0" multi_file_confirm="1" multi_file_column="0" name="Load%20File%20Channel_A_%7Bdate%7D.xlsx%5BEasy%20Data%20Transform%5D" json_manual_col_types="00000" write_header_first_append_only="1" bom="1" pos_v12="2064.674.7" excel_use_style_template="0" single_or_multi="0" overwrite_sheet="1" path="%2FUsers%2Folaf%2Ftmp%2FLoad%20File%20Channel_A_%7Bdate%7D.xlsx" xml_root="root" remove_empty="1" file_type="1" id="136" custom_delimiter="%2A" alias="Load%20File%20Channel_A_%7Btoday%7D" file_comment="%20File%20created%20by%20Easy%20Data%20Transform%20%7Bversion%7D%20at%20%7Bdate%7D%20%7Btime%7D%20" write_header="1" excel_manual_col_formats="00000" json_types="0" xml_row="record" encoding="UTF-8" line_endings="0" quote="0"/>
    </outputs>
    <notes>
        <note id="122" comment="Add%20Channel" pos_v12="388.8-45" color="255%1F255%1F255" arrow="3"/>
        <note id="123" comment="Adds%20date%20from%20meta%20info" pos_v12="-329.4-45" color="255%1F255%1F255" arrow="2"/>
        <note id="125" comment="Reformat%20date" pos_v12="628.2-45" color="255%1F255%1F255" arrow="3"/>
        <note id="131" comment="File%20with%20current%20exchange%20rates" pos_v12="-329.4194.4" color="255%1F255%1F255" arrow="2"/>
        <note id="138" comment="Calculate%20Amount%20in%20USD" pos_v12="867.6-45" color="255%1F255%1F255" arrow="3"/>
        <note id="139" comment="Round%20calculated%20amount%20to%202%20decimal%20places" pos_v12="1107-45" color="255%1F255%1F255" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="121" end_id="124"/>
        <connection start_id="124" end_id="134"/>
        <connection start_id="127" end_id="129"/>
        <connection start_id="128" end_id="136"/>
        <connection start_id="129" end_id="128"/>
        <connection start_id="130" end_id="132"/>
        <connection start_id="132" end_id="121"/>
        <connection start_id="134" end_id="135"/>
        <connection start_id="135" end_id="127"/>
        <connection start_id="137" end_id="132"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
