<!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_25_11_38_30"/>
        <locale value="en_GB"/>
        <id value="7d77050c357507070b747a7409083c00"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2Fbooks%203.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-329.4^74.7" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="Books_Input.csv" schema_extra_cols="0" pos_v12="-329.474.7" watching="0" medium="0" auto_fixed_widths="1" path="%2FUsers%2Folaf%2Ftmp%2FBooks_Input.csv" 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="2" alias="Books_Input" 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="1107^433.8" 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="1107433.8" 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="17" 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"/>
    </inputs>
    <transforms>
        <transform id="3" name="Remove" pos="-90^74.7" pos_v12="-9074.7">
            <parameters>
                <parameter type="11" name="Columns" value="5913142125434676"/>
            </parameters>
        </transform>
        <transform id="5" name="Rename_Cols" pos="149.4^74.7" pos_v12="149.474.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="ISBNFormatQTY%20Sold%2ANORENAME%2APrint%20Manufacturing%20and%20Delivery%20ChargeTotal%20Royalty%20Local%20CurrencyQty%20ReturnedTotal%20Royalty%20Amount%20USDMarketplace"/>
            </parameters>
        </transform>
        <transform id="8" name="New_Col" pos="-329.4^314.1" pos_v12="-329.4314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Sales%20Source"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="9" name="New_Col" pos="-90^314.1" pos_v12="-90314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Author%20Copy%3F"/>
                <parameter type="7" name="New_Value" value="No"/>
            </parameters>
        </transform>
        <transform id="10" name="New_Col" pos="149.4^314.1" pos_v12="149.4314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Type%20of%20Order"/>
                <parameter type="7" name="New_Value" value="Regular"/>
            </parameters>
        </transform>
        <transform id="11" name="New_Col" pos="388.8^314.1" pos_v12="388.8314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Order%20Number"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="12" name="New_Col" pos="628.2^314.1" pos_v12="628.2314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Invoice%20Number"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="14" name="New_Col" pos="867.6^314.1" pos_v12="867.6314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Retailer"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="15" name="New_Col" pos="1107^314.1" pos_v12="1107314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Discount%20Given"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="16" name="New_Col" pos="1346.4^314.1" pos_v12="1346.4314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Currency%20Code"/>
                <parameter type="7" name="New_Value" value="EUR"/>
            </parameters>
        </transform>
        <transform id="18" name="Lookup" pos="1585.8^433.8" pos_v12="1585.8433.8">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Lookup"/>
                <parameter type="0" name="Top_Lookup_Column" value="17"/>
                <parameter type="0" name="Bottom_Lookup_Column" value="1"/>
                <parameter type="0" name="Bottom_Value_Column" value="2"/>
                <parameter type="6" name="Match_Type" value="Exact"/>
                <parameter type="8" name="Fuzziness" value="80"/>
                <parameter type="6" name="Bottom_Values_Used" value="First"/>
                <parameter type="6" name="Fuzzy_Bottom_Values_Used" value="First%20best"/>
                <parameter type="7" name="Delim" value="%2C"/>
                <parameter type="6" name="If_No_Match" value="Use%20no%20match%20value"/>
                <parameter type="7" name="Non_Matching_Value" value=""/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="19" name="Transpose" pos="1346.4^433.8" pos_v12="1346.4433.8">
            <parameters>
                <parameter type="5" name="Header" value="0"/>
            </parameters>
        </transform>
        <transform id="20" name="Rename_Cols" pos="1825.2^433.8" pos_v12="1825.2433.8">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2AExchange%20Rate"/>
            </parameters>
        </transform>
        <transform id="21" name="New_Col" pos="2064.6^433.8" pos_v12="2064.6433.8">
            <parameters>
                <parameter type="7" name="New_Name" value="Notes"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="25" name="Replace_Multi" pos="-329.4^792.9" pos_v12="-329.4792.9">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="16" name="Replace" value="0Perfectbound%20%28Trade%20PaperPaperback0Trade%20Cloth%2FLaminateHardcover"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="28" name="Split" pos="-329.4^912.6" pos_v12="-329.4912.6">
            <parameters>
                <parameter type="0" name="Columns" value="4"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%2F"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Columns"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="29" name="Rename_Cols" pos="-90^912.6" pos_v12="-90912.6">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2AAverage%20List%20PriceUnit%20Price%20Local%20Curreny"/>
            </parameters>
        </transform>
        <transform id="30" name="Remove" pos="149.4^912.6" pos_v12="149.4912.6">
            <parameters>
                <parameter type="11" name="Columns" value="12356789101112131415161718192021"/>
            </parameters>
        </transform>
        <transform id="32" name="If" pos="-329.4^1032.3" pos_v12="-329.41032.3">
            <parameters>
                <parameter type="7" name="New_Name" value="Was%20a%20Return%3F"/>
                <parameter type="10" name="If" value="*StartIf*640*EndIf*YesNo"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="34" name="Copy" pos="-329.4^1152" pos_v12="-329.41152">
            <parameters>
                <parameter type="1" name="Columns" value="19"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="35" name="Rename_Cols" pos="-90^1152" pos_v12="-901152">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2AUnit%20Offer%20Price%20Local%20Currency"/>
            </parameters>
        </transform>
        <transform id="37" name="Calculate" pos="-329.4^1271.7" pos_v12="-329.41271.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Total%20Sale%20Local%20Currency"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="19"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="3"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="40" name="Calculate" pos="-329.4^1511.1" pos_v12="-329.41511.1">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Unit%20Offer%20Price%20USD"/>
                <parameter type="6" name="Operation" value="%2F%20Divide"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="19"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="17"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="41" name="Num_Format" pos="-90^1511.1" pos_v12="-901511.1">
            <parameters>
                <parameter type="1" name="Columns" value="24"/>
                <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>
        <transform id="45" name="Filter" pos="-329.4^1989.9" pos_v12="-329.41989.9">
            <parameters>
                <parameter type="3" name="Columns" value="11640"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="46" name="Replace_Multi" pos="-90^1989.9" pos_v12="-901989.9">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="16" name="Replace" value="5"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="48" name="Calculate" pos="149.4^1989.9" pos_v12="149.41989.9">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Total%20Royalty%20Amount%20USD%20Interim"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="23"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="6"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="49" name="Calculate" pos="388.8^1989.9" pos_v12="388.81989.9">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Total%20Royalty%20Amount%20USD"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="25"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="-1"/>
            </parameters>
        </transform>
        <transform id="53" name="Replace_Multi" pos="388.8^1511.1" pos_v12="388.81511.1">
            <parameters>
                <parameter type="1" name="Columns" value="6"/>
                <parameter type="16" name="Replace" value="5"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="55" name="Stack" pos="867.6^1750.5" pos_v12="867.61750.5">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Header%20name"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
        <transform id="57" name="Remove" pos="628.2^1989.9" pos_v12="628.21989.9">
            <parameters>
                <parameter type="11" name="Columns" value="12345678910111213141516171819202122232426"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="4" comment="remove%20all%20%22ignore%22%20columns" pos_v12="-90-45" color="255%1F255%1F255" arrow="2"/>
        <note id="6" comment="Rename%20to%20target%20column%20name" pos_v12="149.4-45" color="255%1F255%1F255" arrow="3"/>
        <note id="7" comment="Add%20columns%20with%20fixed%20values" pos_v12="-568.8314.1" color="255%1F255%1F255" arrow="2"/>
        <note id="22" comment="File%20with%20the%20current%20valid%20exchange%20rates" pos_v12="867.6433.8" color="255%1F255%1F255" arrow="2"/>
        <note id="23" comment="Data%20ist%20transpoesed%20to%20prepare%20the%20currency%20excange%20rate%20value" pos_v12="1346.4553.5" color="255%1F255%1F255" arrow="1"/>
        <note id="24" comment="Here%20the%20intended%20Currency%20must%20be%20entered%20wihich%20should%20be%20in%20teh%20exchange%20rate%20file%2C%20too" pos_v12="1346.4194.4" color="255%1F255%1F255" arrow="3"/>
        <note id="26" comment="Adapt%20Format" pos_v12="-568.8792.9" color="255%1F255%1F255" arrow="2"/>
        <note id="27" comment="PTD_avg_list_price%20split%20into%202%20fields" pos_v12="-568.8912.6" color="255%1F255%1F255" arrow="2"/>
        <note id="31" comment="Was%20a%20Return%3F" pos_v12="-568.81032.3" color="255%1F255%1F255" arrow="2"/>
        <note id="33" comment="Unit%20Offer%20Price%20Local%20Currency%20-%20not%20sure%20if%20this%20is%20the%20intended%20transaction%0A" pos_v12="-568.81152" color="251%1F128%1F114" arrow="0"/>
        <note id="36" comment="Total%20Sale%20Local%20Currency" pos_v12="-568.81271.7" color="255%1F255%1F255" arrow="2"/>
        <note id="38" comment="Further%20calculation%20skipped%2C%20completeness%20to%20be%20checked%21%21%21%21" pos_v12="-329.41391.4" color="251%1F128%1F114" arrow="0"/>
        <note id="39" comment="Unit%20Offer%20Price%20USD" pos_v12="-568.81511.1" color="255%1F255%1F255" arrow="2"/>
        <note id="42" comment="Further%20calculation%20skipped%2C%20completeness%20to%20be%20checked%21%21%21%21" pos_v12="-329.41630.8" color="251%1F128%1F114" arrow="0"/>
        <note id="43" comment="Row%20duplication%20if%20required%20for%20Qty%20Returned" pos_v12="-568.81989.9" color="255%1F255%1F179" arrow="2"/>
        <note id="47" comment="Set%20the%20sold%20Qty%20to%20NULL%20as%20this%20is%20the%20Record%20for%20returned%20QTY%20%28Don%27t%20know%20if%20intended%29" pos_v12="-901870.2" color="255%1F255%1F255" arrow="3"/>
        <note id="50" comment="make%20it%20negative" pos_v12="388.81870.2" color="255%1F255%1F255" arrow="3"/>
        <note id="52" comment="I%20think%20here%20I%20used%20the%20wrong%20columns" pos_v12="149.42109.6" color="251%1F128%1F114" arrow="1"/>
        <note id="54" comment="set%20Return%20QTY%20to%20%22%22%20%28Returne%20QTY%20are%20treated%20in%20the%20filter%20condition%29%0A" pos_v12="388.81391.4" color="255%1F255%1F255" arrow="0"/>
        <note id="56" comment="Merge%20the%20data%20%28now%20the%20duplicated%20Rows%20are%20back%20into%20one%20table%29" pos_v12="867.61630.8" color="113%1F245%1F183" arrow="0"/>
    </notes>
    <connections>
        <connection start_id="2" end_id="3"/>
        <connection start_id="3" end_id="5"/>
        <connection start_id="5" end_id="8"/>
        <connection start_id="8" end_id="9"/>
        <connection start_id="9" end_id="10"/>
        <connection start_id="10" end_id="11"/>
        <connection start_id="11" end_id="12"/>
        <connection start_id="12" end_id="14"/>
        <connection start_id="14" end_id="15"/>
        <connection start_id="15" end_id="16"/>
        <connection start_id="16" end_id="18"/>
        <connection start_id="17" end_id="19"/>
        <connection start_id="18" end_id="20"/>
        <connection start_id="19" end_id="18"/>
        <connection start_id="20" end_id="21"/>
        <connection start_id="21" end_id="25"/>
        <connection start_id="25" end_id="28"/>
        <connection start_id="28" end_id="29"/>
        <connection start_id="29" end_id="30"/>
        <connection start_id="30" end_id="32"/>
        <connection start_id="32" end_id="34"/>
        <connection start_id="34" end_id="35"/>
        <connection start_id="35" end_id="37"/>
        <connection start_id="37" end_id="40"/>
        <connection start_id="40" end_id="41"/>
        <connection start_id="41" end_id="45"/>
        <connection start_id="41" end_id="53"/>
        <connection start_id="45" end_id="46"/>
        <connection start_id="46" end_id="48"/>
        <connection start_id="48" end_id="49"/>
        <connection start_id="49" end_id="57"/>
        <connection start_id="53" end_id="55"/>
        <connection start_id="57" end_id="55"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
