<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="65"/>
        <last_saved_by value="Easy_Data_Transform_v1_43_0_on_Windows_10_Version_2009_at_2023_09_27_18_08_08"/>
        <locale value="en_US"/>
        <id value="1234"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="T%3A%5CDownloads%5CHelpWithBreakingOut.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-329.4^-284.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="BULK%20ORDER%202.csv" pos_v12="-329.4-284.4" watching="0" medium="0" ignore_excel_hidden="0" auto_fixed_widths="1" path="T%3A%5CDownloads%5CBULK%20ORDER%202.csv" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="41" alias="BULK%20ORDER%202" custom_delimiter="%2A" ignore_repeated_delim="0" meta_text="%24%28FilePath%29%20%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="2" name="Gather" pos="-90^-164.7" pos_v12="-90-164.7">
            <parameters>
                <parameter type="1" name="Columns" value="89101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142"/>
                <parameter type="7" name="Key_Column" value="Key"/>
                <parameter type="7" name="Value_Column" value="Value"/>
            </parameters>
        </transform>
        <transform id="3" name="Filter" pos="-329.4^74.7" comment="Quantity" pos_v12="-329.474.7">
            <parameters>
                <parameter type="3" name="Columns" value="1098Qty%7CQuantity1020"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="4" name="Replace_Multi" pos="-329.4^194.4" pos_v12="-329.4194.4">
            <parameters>
                <parameter type="1" name="Columns" value="9"/>
                <parameter type="16" name="Replace" value="2%5Cs%2A%5C%28Qty%5C%29%7CQuantity%5Cs%2A%24"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
            </parameters>
        </transform>
        <transform id="5" name="Split" pos="-329.4^314.1" pos_v12="-329.4314.1">
            <parameters>
                <parameter type="0" name="Columns" value="9"/>
                <parameter type="6" name="Delimiter_Type" value="Regex%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%5CW%2B%5Cs%2B"/>
                <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="6" name="Rename_Cols" pos="-329.4^433.8" pos_v12="-329.4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QuantitySKUItemColorLogo"/>
            </parameters>
        </transform>
        <transform id="7" name="Remove" pos="-329.4^553.5" pos_v12="-329.4553.5">
            <parameters>
                <parameter type="11" name="Columns" value="123456781011121314"/>
            </parameters>
        </transform>
        <transform id="8" name="Reorder" pos="-329.4^673.2" pos_v12="-329.4673.2">
            <parameters>
                <parameter type="4" name="Columns" value="12345678101112139"/>
            </parameters>
        </transform>
        <transform id="9" name="Filter" pos="149.4^74.7" comment="Size" pos_v12="149.474.7">
            <parameters>
                <parameter type="3" name="Columns" value="1030Size420"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="10" name="Replace_Multi" pos="149.4^194.4" pos_v12="149.4194.4">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="16" name="Replace" value="2%5Cs%2A%3E%2B%5Cs%2ASize%5Cs%2A%24"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
            </parameters>
        </transform>
        <transform id="11" name="Split" pos="149.4^314.1" pos_v12="149.4314.1">
            <parameters>
                <parameter type="0" name="Columns" value="3"/>
                <parameter type="6" name="Delimiter_Type" value="Regex%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%5CW%2B%5Cs%2B"/>
                <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="12" name="Rename_Cols" pos="149.4^433.8" pos_v12="149.4433.8">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2ASizeSKUItemColor"/>
            </parameters>
        </transform>
        <transform id="13" name="Remove" pos="149.4^553.5" pos_v12="149.4553.5">
            <parameters>
                <parameter type="11" name="Columns" value="124567"/>
            </parameters>
        </transform>
        <transform id="14" name="Reorder" pos="149.4^673.2" pos_v12="149.4673.2">
            <parameters>
                <parameter type="4" name="Columns" value="124563"/>
            </parameters>
        </transform>
        <transform id="15" name="Concat" pos="-329.4^792.9" pos_v12="-329.4792.9">
            <parameters>
                <parameter type="1" name="Columns" value="1291011"/>
                <parameter type="7" name="Delimiter" value="-"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="16" name="Concat" pos="149.4^792.9" pos_v12="149.4792.9">
            <parameters>
                <parameter type="1" name="Columns" value="12345"/>
                <parameter type="7" name="Delimiter" value="-"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="18" name="Remove" pos="-90^1032.3" pos_v12="-901032.3">
            <parameters>
                <parameter type="11" name="Columns" value="1234567891011121320"/>
            </parameters>
        </transform>
        <transform id="40" name="Join" pos="-90^912.6" pos_v12="-90912.6">
            <parameters>
                <parameter type="0" name="Column_1" value="14"/>
                <parameter type="5" name="Include_Non_Matching_1" value="1"/>
                <parameter type="0" name="Column_2" value="7"/>
                <parameter type="5" name="Include_Non_Matching_2" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Detailed_Report" value="0"/>
            </parameters>
        </transform>
        <transform id="44" name="Remove" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="11" name="Columns" value="12910"/>
            </parameters>
        </transform>
        <transform id="45" name="Reorder" pos="-90^1152" pos_v12="-901152">
            <parameters>
                <parameter type="4" name="Columns" value="1234567891011121413"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="2" end_id="3"/>
        <connection start_id="2" end_id="44"/>
        <connection start_id="3" end_id="4"/>
        <connection start_id="4" end_id="5"/>
        <connection start_id="5" end_id="6"/>
        <connection start_id="6" end_id="7"/>
        <connection start_id="7" end_id="8"/>
        <connection start_id="8" end_id="15"/>
        <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="13"/>
        <connection start_id="13" end_id="14"/>
        <connection start_id="14" end_id="16"/>
        <connection start_id="15" end_id="40"/>
        <connection start_id="16" end_id="40"/>
        <connection start_id="18" end_id="45"/>
        <connection start_id="40" end_id="18"/>
        <connection start_id="41" end_id="2"/>
        <connection start_id="44" end_id="9"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
