<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="69"/>
        <last_saved_by value="Rick_Quatro_using_Easy_Data_Transform_v1_46_1_on_Windows_10_Version_2009_at_2024_01_09_15_42_24"/>
        <locale value="en_US"/>
        <id value="76020500337707000b7576010c0a38"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="C%3A%5CDATA-10%5CScripts%5CJMCC%5C20231129-ABX-IPC%5CJM-IPC-GetEffectivities3.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^792.9" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="input-to-effectivities3.csv" pos_v12="-90792.9" watching="0" medium="0" ignore_excel_hidden="0" auto_fixed_widths="1" path="C%3A%5CDATA-10%5CScripts%5CJMCC%5C20231129-ABX-IPC%5Cinput-to-effectivities3.csv" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="5" alias="Master%20%20Config%20Tracker%20%28old%20li" 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="47" name="Gather" pos="149.4^792.9" pos_v12="149.4792.9">
            <parameters>
                <parameter type="1" name="Columns" value="234567891011121314151617181920212223242526"/>
                <parameter type="7" name="Key_Column" value="key"/>
                <parameter type="7" name="Value_Column" value="value"/>
            </parameters>
        </transform>
        <transform id="48" name="Replace_Multi" pos="388.8^792.9" pos_v12="388.8792.9">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="16" name="Replace" value="3Y2%5BxX%5D"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="49" name="Sort" pos="628.2^792.9" pos_v12="628.2792.9">
            <parameters>
                <parameter type="2" name="Columns" value="2-3"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Minimum"/>
                <parameter type="0" name="Rank_By" value="0"/>
            </parameters>
        </transform>
        <transform id="50" name="Fill" pos="-90^912.6" pos_v12="-90912.6">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="6" name="Direction" value="Down"/>
            </parameters>
        </transform>
        <transform id="51" name="Sort" pos="149.4^912.6" pos_v12="149.4912.6">
            <parameters>
                <parameter type="2" name="Columns" value="12"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Minimum"/>
                <parameter type="0" name="Rank_By" value="0"/>
            </parameters>
        </transform>
        <transform id="52" name="Spread" pos="388.8^912.6" pos_v12="388.8912.6">
            <parameters>
                <parameter type="0" name="Key_Column" value="2"/>
                <parameter type="0" name="Value_Column" value="3"/>
                <parameter type="7" name="Missing_Value" value=""/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="53" name="Replace_Multi" pos="628.2^912.6" pos_v12="628.2912.6">
            <parameters>
                <parameter type="1" name="Columns" value="234567891011121314151617181920212223242526"/>
                <parameter type="16" name="Replace" value="0Y"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="54" name="Header" pos="-90^1032.3" pos_v12="-901032.3">
            <parameters>
                <parameter type="8" name="Num_Rows" value="1"/>
                <parameter type="6" name="Mode" value="Overwrite"/>
                <parameter type="7" name="Delimiter" value=""/>
            </parameters>
        </transform>
        <transform id="55" name="Rename_Cols" pos="149.4^1032.3" pos_v12="149.41032.3">
            <parameters>
                <parameter type="13" name="RenameColumns" value="_ata%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%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A"/>
            </parameters>
        </transform>
        <transform id="56" name="Reorder" pos="388.8^1032.3" pos_v12="388.81032.3">
            <parameters>
                <parameter type="4" name="Columns" value="1171819202122151623465798121011131423242526"/>
            </parameters>
        </transform>
        <transform id="57" name="Concat" pos="628.2^1032.3" pos_v12="628.21032.3">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="_effectivities"/>
                <parameter type="1" name="Columns" value="234567891011121413151617181920212223242526"/>
                <parameter type="7" name="Delimiter" value="%2C%20"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="58" name="Remove" pos="-90^1152" pos_v12="-901152">
            <parameters>
                <parameter type="11" name="Columns" value="127"/>
            </parameters>
        </transform>
    </transforms>
    <outputs>
        <output enable_output="1" pos="149.4^1152" delimiter="1" html_encode="1" excel_output="0" multi_file_confirm="1" multi_file_column="0" name="_abx-ipc-effectivities-2.xml" json_manual_col_types="00" write_header_first_append_only="1" bom="1" pos_v12="149.41152" single_or_multi="0" overwrite_sheet="1" path="C%3A%5CDATA-10%5CScripts%5CJMCC%5C20231129-ABX-IPC%5C_abx-ipc-effectivities-2.xml" xml_root="root" remove_empty="1" file_type="5" id="59" custom_delimiter="%2A" alias="_abx-ipc-effectivities-2" file_comment="%20File%20created%20by%20Easy%20Data%20Transform%20%7Bversion%7D%20at%20%7Bdate%7D%20%7Btime%7D%20" write_header="1" json_types="0" excel_manual_col_formats="00" xml_row="record" encoding="UTF-8" line_endings="0" quote="0"/>
    </outputs>
    <notes/>
    <connections>
        <connection start_id="5" end_id="47"/>
        <connection start_id="47" end_id="48"/>
        <connection start_id="48" end_id="49"/>
        <connection start_id="49" end_id="50"/>
        <connection start_id="50" end_id="51"/>
        <connection start_id="51" end_id="52"/>
        <connection start_id="52" end_id="53"/>
        <connection start_id="53" end_id="54"/>
        <connection start_id="54" end_id="55"/>
        <connection start_id="55" end_id="56"/>
        <connection start_id="56" end_id="57"/>
        <connection start_id="57" end_id="58"/>
        <connection start_id="58" end_id="59"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
