<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="70"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v1_46_5_on_macOS_14_4_at_2024_05_02_19_36_03"/>
        <locale value="de_DE"/>
        <id value="7d02050b337707040b757601080a3808"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2Flookup%20contains.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="0" ignore_empty_cols="0" trim="1" file_type="0" id="0" custom_delimiter="%2A" ignore_repeated_delim="0" text="7%20Ply%204X4%20Carton%0A36%22%20Polybag%0A39%22%20Polybag%0ACow%20leather" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="149.4^194.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="149.4194.4" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="2" custom_delimiter="%2A" ignore_repeated_delim="0" text="Contains%20%7C%20Category%0ACarton%20%7C%20Packaging%0APolybag%20%7C%20Packaging%0ACow%20%7C%20Raw%20Material" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1" name="If" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="7" name="New_Name" value="LookFor"/>
                <parameter type="10" name="If" value="*StartIf*10Carton*EndIf*Carton*StartIf*10Polybag*EndIf*Polybag*StartIf*10Cow*EndIf*Cow"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="3" name="Lookup" pos="388.8^74.7" pos_v12="388.874.7">
            <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="2"/>
                <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="4" name="Concat" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Concat%20Cols"/>
                <parameter type="1" name="Columns" value="13"/>
                <parameter type="7" name="Delimiter" value="%20%7C%20"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="5" name="Remove" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="11" name="Columns" value="14"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="6" comment="Lookup%20table" pos_v12="-90194.4" color="255%1F255%1F255" arrow="2"/>
        <note id="7" comment="Source%20data" pos_v12="-90-164.7" color="255%1F255%1F255" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="0" end_id="1"/>
        <connection start_id="1" end_id="3"/>
        <connection start_id="2" end_id="3"/>
        <connection start_id="3" end_id="4"/>
        <connection start_id="4" end_id="5"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
