<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="23"/>
        <last_saved_by value="Easy_Data_Transform_v1_11_3_on_macOS_10_16_at_2020_12_31_06_01_12"/>
        <locale value="en_US"/>
        <id value="77030508307407030a7176010b083807"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Fdanfeliciano%2FDownloads%2FPurchase%20order%20sequence.transform"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="1" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" auto_fixed_widths="1" header="1" trim="1" file_type="0" id="33" text="Invoice%20id%2CDate%2CAmount%20Paid%2Cemail%2Cfirstname%2Clastname%2CProduct%20ID%2CBase%20Product%20Name%2CCustomer%20ID%0A6437664%2C2015-11-27%207%3A32%3A39%2C%240.00%2Cfreebie%40gmail.com%2Cfree%2CBeforebuying%2C10%2CFree%20Sampler%2C32965477%0A6438605%2C2017-11-27%209%3A04%3A03%2C%2469.00%2Cpayee%40gmail.com%2CPaid%2CFirst%2C20%2CPaid%20Product%2C32969991%0A6449701%2C2020-05-27%2019%3A34%3A36%2C%2469.00%2Charry%40gmail.com%2CAnn%2CKlein%2C20%2CPaid%20Product%2C33023111%0A6454481%2C2020-07-27%2023%3A11%3A17%2C%240.00%2Cgina%40gmail.com%2CFernando%2CSantos%2C10%2CFree%20Sampler%2C33044226%0A6454650%2C2020-08-27%2023%3A20%3A07%2C%2469.00%2Cfreebie%40gmail.com%2Cfree%2CBeforebuying%2C20%2CPaid%20Product%2C33044441%0A6455139%2C2020-09-27%2023%3A47%3A15%2C%2469.00%2Cbiff%40gmail.com%2CJulianne%2CMcCartney%2C20%2CPaid%20Product%2C33047054%0A6455352%2C2020-11-27%2023%3A58%3A25%2C%240.00%2Cpayee%40gmail.com%2CPaid%2CFirst%2C10%2CFree%20Sampler%2C33047878" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="36" name="Remove" pos="388.8^-45" comment="Get%20rid%20of%20unneeded%20columns" pos_v12="388.8-45">
            <parameters>
                <parameter type="11" name="Columns" value="247"/>
            </parameters>
        </transform>
        <transform id="39" name="Sort" pos="628.2^-45" comment="Sort%20for%20unique%20transform.%20List%20products%20in%20purchased%20sequnence%0A" pos_v12="628.2-45">
            <parameters>
                <parameter type="2" name="Columns" value="132"/>
            </parameters>
        </transform>
        <transform id="42" name="Extract" pos="149.4^-45" comment="Correrct%20date%20forrmat" pos_v12="149.4-45">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="8" name="Length" value="10"/>
                <parameter type="6" name="From" value="Start"/>
                <parameter type="8" name="Offset" value="0"/>
            </parameters>
        </transform>
        <transform id="44" name="Unique" pos="867.6^-45" pos_v12="867.6-45">
            <parameters>
                <parameter type="15" name="Column_Options" value="707"/>
                <parameter type="7" name="Delim" value="%2C"/>
                <parameter type="5" name="Count" value="0"/>
            </parameters>
        </transform>
        <transform id="45" name="Split" pos="-90^194.4" pos_v12="-90194.4">
            <parameters>
                <parameter type="0" name="Columns" value="1"/>
                <parameter type="7" name="Delimiter" value="%2C"/>
                <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="46" name="Javascript" pos="149.4^194.4" pos_v12="149.4194.4">
            <parameters>
                <parameter type="7" name="New_Name" value="Years"/>
                <parameter type="12" name="Script" value="%2F%2F%20calculates%20years%20replace%20365%20with%2012%20to%20calculate%20months%20or%20remove%20365%20to%20calculate%20days%0A%0Areturn%20%28%20new%20Date%28%24%28Date2%29%29%20-%20new%20Date%28%24%28Date1%29%29%20%29%20%2F%281000%20%2A%2060%20%2A%2060%20%2A%2024%20%2A%20365%29"/>
            </parameters>
        </transform>
        <transform id="94" name="Filter" pos="388.8^194.4" pos_v12="388.8194.4">
            <parameters>
                <parameter type="3" name="Columns" value="113010%2C20"/>
            </parameters>
        </transform>
        <transform id="95" name="Substitute" pos="628.2^194.4" pos_v12="628.2194.4">
            <parameters>
                <parameter type="7" name="New_Name" value="SampleFirst"/>
                <parameter type="12" name="Script" value="Client%20%24%28email%29%20ordered%20the%20sample%20before%20the%20product%20%28%24%28Product%20ID%29%29%20and%20it%20took%20%24%286%29%20years."/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <connections>
        <connection start_id="33" end_id="42"/>
        <connection start_id="36" end_id="39"/>
        <connection start_id="39" end_id="44"/>
        <connection start_id="42" end_id="36"/>
        <connection start_id="44" end_id="45"/>
        <connection start_id="45" end_id="46"/>
        <connection start_id="46" end_id="94"/>
        <connection start_id="94" end_id="95"/>
    </connections>
    <batch_values/>
</root>
