<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="75"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v2_3_0_on_macOS_15_4_arm64_at_2025_04_12_16_51_24"/>
        <locale value="en_GB"/>
        <id value="7f76050b367507060b747a740a003c"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2FField_mismatches_stable.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input worksheet="Tabelle1" 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="1" name="Input%204.xlsx%5BTabelle1%5D" schema_extra_cols="0" pos_v12="-329.474.7" watching="0" medium="0" auto_fixed_widths="1" path="%2FUsers%2Folaf%2Ftmp%2FInput%204.xlsx" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_col_name="X1X2X3IDPIDX4" schema_reorder_cols="0" trim="1" file_type="1" id="0" alias="Input%201" custom_delimiter="%2A" schema_missing_value="" 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="1" name="Sort" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="2" name="Columns" value="1"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Minimum"/>
                <parameter type="0" name="Rank_By" value="0"/>
                <parameter type="5" name="Intelligent_Sort" value="1"/>
                <parameter type="5" name="Locale_Aware_Sort" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="2" name="Dedupe" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="1" name="Columns" value="4"/>
                <parameter type="6" name="Match_Type" value="Exact"/>
                <parameter type="8" name="Fuzziness" value="80"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Ignore_Spaces" value="0"/>
                <parameter type="5" name="Ignore_Punctuation" value="0"/>
                <parameter type="6" name="Dedupe_Mode" value="Remove%20duplicates"/>
                <parameter type="5" name="Drilldown" value="0"/>
            </parameters>
        </transform>
        <transform id="4" name="If" pos="-90^74.7" pos_v12="-9074.7">
            <parameters>
                <parameter type="7" name="New_Name" value="ID"/>
                <parameter type="10" name="If" value="*StartIf*420*EndIf*%24%28ID%29%24%28PID%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="5" name="Remove" pos="149.4^74.7" pos_v12="149.474.7">
            <parameters>
                <parameter type="11" name="Columns" value="12367"/>
            </parameters>
        </transform>
        <transform id="6" name="Reorder" pos="388.8^74.7" pos_v12="388.874.7">
            <parameters>
                <parameter type="4" name="Columns" value="12354"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="0" end_id="4"/>
        <connection start_id="1" end_id="2"/>
        <connection start_id="4" end_id="5"/>
        <connection start_id="5" end_id="6"/>
        <connection start_id="6" end_id="1"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
