<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="62"/>
        <last_saved_by value="Easy_Data_Transform_v1_39_1_on_Windows_10_Version_2009_at_2023_02_25_23_40_39"/>
        <locale value="en_US"/>
        <id value="1234"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="T%3A%5CSolution.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-568.8^74.7" ignored_rows="0" show_meta="3" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-568.874.7" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="0" custom_delimiter="%2A" ignore_repeated_delim="0" text="Numbers%0D%0A1%0D%0A2%0D%0A3%0D%0A4%0D%0A5%0D%0A6%0D%0A7%0D%0A8%0D%0A9%0D%0A10%0D%0A11%0D%0A12%0D%0A13%0D%0A14%0D%0A15%0D%0A16%0D%0A17%0D%0A18%0D%0A19%0D%0A20%0D%0A21%0D%0A22%0D%0A23%0D%0A24%0D%0A25%0D%0A26%0D%0A27%0D%0A28%0D%0A29%0D%0A30%0D%0A31%0D%0A32%0D%0A33%0D%0A34%0D%0A35%0D%0A36%0D%0A37%0D%0A38%0D%0A39%0D%0A40%0D%0A41%0D%0A42%0D%0A43%0D%0A44%0D%0A45%0D%0A46%0D%0A47%0D%0A48%0D%0A49%0D%0A50%0D%0A51%0D%0A52%0D%0A53%0D%0A54%0D%0A55%0D%0A56%0D%0A57%0D%0A58%0D%0A59%0D%0A60%0D%0A61%0D%0A62%0D%0A63%0D%0A64%0D%0A65%0D%0A66%0D%0A67%0D%0A68%0D%0A69%0D%0A70%0D%0A71%0D%0A72%0D%0A73%0D%0A74%0D%0A75%0D%0A76%0D%0A77%0D%0A78%0D%0A79%0D%0A80%0D%0A81%0D%0A82%0D%0A83%0D%0A84%0D%0A85%0D%0A86%0D%0A87%0D%0A88%0D%0A89%0D%0A90%0D%0A91%0D%0A92%0D%0A93%0D%0A94%0D%0A95%0D%0A96%0D%0A97%0D%0A98%0D%0A99%0D%0A100%0D%0A101%0D%0A102%0D%0A103%0D%0A104%0D%0A105%0D%0A106%0D%0A107%0D%0A108%0D%0A109%0D%0A110%0D%0A111%0D%0A112%0D%0A113%0D%0A114%0D%0A115%0D%0A116%0D%0A117%0D%0A118%0D%0A119%0D%0A120%0D%0A121%0D%0A122%0D%0A123%0D%0A124%0D%0A125%0D%0A126%0D%0A127%0D%0A128%0D%0A129%0D%0A130%0D%0A131%0D%0A132%0D%0A133%0D%0A134%0D%0A135%0D%0A136%0D%0A137%0D%0A138%0D%0A139%0D%0A140%0D%0A141%0D%0A142%0D%0A143%0D%0A144%0D%0A145%0D%0A146%0D%0A147%0D%0A148%0D%0A149%0D%0A150%0D%0A151%0D%0A152%0D%0A153%0D%0A154%0D%0A155%0D%0A156%0D%0A157%0D%0A158%0D%0A159%0D%0A160%0D%0A161%0D%0A162%0D%0A163%0D%0A164%0D%0A165%0D%0A166%0D%0A167%0D%0A168%0D%0A169%0D%0A170%0D%0A171%0D%0A172%0D%0A173%0D%0A174%0D%0A175%0D%0A176%0D%0A177%0D%0A178%0D%0A179%0D%0A180%0D%0A181%0D%0A182%0D%0A183%0D%0A184%0D%0A185%0D%0A186%0D%0A187%0D%0A188%0D%0A189%0D%0A190%0D%0A191%0D%0A192%0D%0A193%0D%0A194%0D%0A195%0D%0A196%0D%0A197%0D%0A198%0D%0A199%0D%0A200%0D%0A201%0D%0A202%0D%0A203%0D%0A204%0D%0A205%0D%0A206%0D%0A207%0D%0A208%0D%0A209%0D%0A210%0D%0A211%0D%0A212%0D%0A213%0D%0A214%0D%0A215%0D%0A216%0D%0A217%0D%0A218%0D%0A219%0D%0A220%0D%0A221%0D%0A222%0D%0A223%0D%0A224%0D%0A225%0D%0A226%0D%0A227%0D%0A228%0D%0A229%0D%0A230%0D%0A231%0D%0A232%0D%0A233%0D%0A234%0D%0A235%0D%0A236%0D%0A237%0D%0A238%0D%0A239%0D%0A240%0D%0A241%0D%0A242%0D%0A243%0D%0A244%0D%0A245%0D%0A246%0D%0A247%0D%0A248%0D%0A249%0D%0A250%0D%0A251%0D%0A252%0D%0A253%0D%0A254%0D%0A255%0D%0A256%0D%0A257%0D%0A258%0D%0A259%0D%0A260%0D%0A261%0D%0A262%0D%0A263%0D%0A264%0D%0A265%0D%0A266%0D%0A267%0D%0A268%0D%0A269%0D%0A270%0D%0A271%0D%0A272%0D%0A273%0D%0A274%0D%0A275%0D%0A276%0D%0A277%0D%0A278%0D%0A279%0D%0A280%0D%0A281%0D%0A282%0D%0A283%0D%0A284%0D%0A285%0D%0A286%0D%0A287%0D%0A288%0D%0A289%0D%0A290%0D%0A291%0D%0A292%0D%0A293%0D%0A294%0D%0A295%0D%0A296%0D%0A297%0D%0A298%0D%0A299%0D%0A300%0D%0A301%0D%0A302%0D%0A303%0D%0A304%0D%0A305%0D%0A306%0D%0A307%0D%0A308%0D%0A309%0D%0A310%0D%0A311%0D%0A312%0D%0A313%0D%0A314%0D%0A315%0D%0A316%0D%0A317%0D%0A318%0D%0A319%0D%0A320%0D%0A321%0D%0A322%0D%0A323%0D%0A324%0D%0A325%0D%0A326%0D%0A327%0D%0A328%0D%0A329%0D%0A330%0D%0A331%0D%0A332%0D%0A333%0D%0A334%0D%0A335%0D%0A336%0D%0A337%0D%0A338%0D%0A339%0D%0A340%0D%0A341%0D%0A342%0D%0A343%0D%0A344%0D%0A345%0D%0A346%0D%0A347%0D%0A348%0D%0A349%0D%0A350%0D%0A351%0D%0A352%0D%0A353%0D%0A354%0D%0A355%0D%0A356%0D%0A357%0D%0A358%0D%0A359%0D%0A360%0D%0A361%0D%0A362%0D%0A363%0D%0A364%0D%0A365%0D%0A366%0D%0A367%0D%0A368%0D%0A369%0D%0A370%0D%0A371%0D%0A372%0D%0A373%0D%0A374%0D%0A375%0D%0A376%0D%0A377%0D%0A378%0D%0A379%0D%0A380%0D%0A381%0D%0A382%0D%0A383%0D%0A384%0D%0A385%0D%0A386%0D%0A387%0D%0A388%0D%0A389%0D%0A390%0D%0A391%0D%0A392%0D%0A393%0D%0A394%0D%0A395%0D%0A396%0D%0A397%0D%0A398%0D%0A399%0D%0A400%0D%0A401%0D%0A402%0D%0A403%0D%0A404%0D%0A405%0D%0A406%0D%0A407%0D%0A408%0D%0A409%0D%0A410%0D%0A411%0D%0A412%0D%0A413%0D%0A414%0D%0A415%0D%0A416%0D%0A417%0D%0A418%0D%0A419%0D%0A420%0D%0A421%0D%0A422%0D%0A423%0D%0A424%0D%0A425%0D%0A426%0D%0A427%0D%0A428%0D%0A429%0D%0A430%0D%0A431%0D%0A432%0D%0A433%0D%0A434%0D%0A435%0D%0A436%0D%0A437%0D%0A438%0D%0A439%0D%0A440%0D%0A441%0D%0A442%0D%0A443%0D%0A444%0D%0A445%0D%0A446%0D%0A447%0D%0A448%0D%0A449%0D%0A450%0D%0A451%0D%0A452%0D%0A453%0D%0A454%0D%0A455%0D%0A456%0D%0A457%0D%0A458%0D%0A459%0D%0A460%0D%0A461%0D%0A462%0D%0A463%0D%0A464%0D%0A465%0D%0A466%0D%0A467%0D%0A468%0D%0A469%0D%0A470%0D%0A471%0D%0A472%0D%0A473%0D%0A474%0D%0A475%0D%0A476%0D%0A477%0D%0A478%0D%0A479%0D%0A480%0D%0A" meta_text="%24%28DataRows%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="6" name="Javascript" pos="-329.4^74.7" pos_v12="-329.474.7">
            <parameters>
                <parameter type="7" name="New_Name" value="half"/>
                <parameter type="6" name="Type_As" value="Number%2FBoolean%2FString"/>
                <parameter type="12" name="Script" value="if%20%28%24%28Numbers%29%20%3E%28%20%24%28Meta%20Info%29%20%2F%202%29%29%0A%20%20return%202%0Aelse%20return%201"/>
            </parameters>
        </transform>
        <transform id="1519" name="Filter" pos="-90^194.4" pos_v12="-90194.4">
            <parameters>
                <parameter type="3" name="Columns" value="11312"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="1520" name="Filter" pos="-90^-45" pos_v12="-90-45">
            <parameters>
                <parameter type="3" name="Columns" value="11311"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="1521" name="Sort" pos="149.4^194.4" pos_v12="149.4194.4">
            <parameters>
                <parameter type="2" name="Columns" value="-1"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Maximum"/>
                <parameter type="0" name="Rank_By" value="1"/>
            </parameters>
        </transform>
        <transform id="1522" name="Row_Num" pos="388.8^194.4" pos_v12="388.8194.4">
            <parameters>
                <parameter type="8" name="Start_At" value="1"/>
                <parameter type="8" name="Increment" value="1"/>
                <parameter type="8" name="Every" value="1"/>
            </parameters>
        </transform>
        <transform id="1523" name="Row_Num" pos="388.8^-45" pos_v12="388.8-45">
            <parameters>
                <parameter type="8" name="Start_At" value="1"/>
                <parameter type="8" name="Increment" value="1"/>
                <parameter type="8" name="Every" value="1"/>
            </parameters>
        </transform>
        <transform id="1524" name="Join" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="0" name="Column_1" value="4"/>
                <parameter type="5" name="Include_Non_Matching_1" value="1"/>
                <parameter type="0" name="Column_2" value="4"/>
                <parameter type="5" name="Include_Non_Matching_2" value="1"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Detailed_Report" value="0"/>
            </parameters>
        </transform>
        <transform id="1525" name="Remove" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="11" name="Columns" value="15"/>
            </parameters>
        </transform>
        <transform id="1526" name="Rename_Cols" pos="1346.4^74.7" pos_v12="1346.474.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="FirstHalfSecondHalf"/>
            </parameters>
        </transform>
        <transform id="1542" name="Copy" pos="1585.8^-45" pos_v12="1585.8-45">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1543" name="Concat_Rows" pos="1825.2^-45" pos_v12="1825.2-45">
            <parameters>
                <parameter type="6" name="Mode" value="Fixed"/>
                <parameter type="8" name="Rows" value="2"/>
                <parameter type="6" name="While_Or_Until" value="Until"/>
                <parameter type="6" name="Matches" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Value" value=""/>
                <parameter type="0" name="Key_Column" value="0"/>
                <parameter type="5" name="Repeat_Key_Column" value="1"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="6" name="Concat_Value" value="Omit"/>
            </parameters>
        </transform>
        <transform id="1544" name="Copy" pos="1585.8^194.4" pos_v12="1585.8194.4">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1545" name="Concat_Rows" pos="2064.6^194.4" pos_v12="2064.6194.4">
            <parameters>
                <parameter type="6" name="Mode" value="Fixed"/>
                <parameter type="8" name="Rows" value="2"/>
                <parameter type="6" name="While_Or_Until" value="Until"/>
                <parameter type="6" name="Matches" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Value" value=""/>
                <parameter type="0" name="Key_Column" value="0"/>
                <parameter type="5" name="Repeat_Key_Column" value="1"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="6" name="Concat_Value" value="Omit"/>
            </parameters>
        </transform>
        <transform id="1546" name="Offset" pos="1825.2^194.4" pos_v12="1825.2194.4">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="8" name="Offset_Amount" value="1"/>
                <parameter type="6" name="Offset_Direction" value="Up"/>
                <parameter type="5" name="Wraparound" value="1"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="1547" name="Remove" pos="2304^194.4" pos_v12="2304194.4">
            <parameters>
                <parameter type="11" name="Columns" value="456"/>
            </parameters>
        </transform>
        <transform id="1548" name="Remove" pos="2304^-45" pos_v12="2304-45">
            <parameters>
                <parameter type="11" name="Columns" value="234"/>
            </parameters>
        </transform>
        <transform id="1556" name="Join" pos="2782.8^74.7" pos_v12="2782.874.7">
            <parameters>
                <parameter type="0" name="Column_1" value="3"/>
                <parameter type="5" name="Include_Non_Matching_1" value="0"/>
                <parameter type="0" name="Column_2" value="1"/>
                <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="1557" name="Concat_Rows" pos="3022.2^74.7" pos_v12="3022.274.7">
            <parameters>
                <parameter type="6" name="Mode" value="Variable"/>
                <parameter type="8" name="Rows" value="4"/>
                <parameter type="6" name="While_Or_Until" value="Until"/>
                <parameter type="6" name="Matches" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Value" value="END"/>
                <parameter type="0" name="Key_Column" value="1"/>
                <parameter type="5" name="Repeat_Key_Column" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="6" name="Concat_Value" value="Omit"/>
            </parameters>
        </transform>
        <transform id="1558" name="Transpose" pos="3261.6^74.7" pos_v12="3261.674.7">
            <parameters>
                <parameter type="5" name="Header" value="0"/>
            </parameters>
        </transform>
        <transform id="1559" name="Remove" pos="3501^74.7" pos_v12="350174.7">
            <parameters>
                <parameter type="11" name="Columns" value="2"/>
            </parameters>
        </transform>
        <transform id="1560" name="Dedupe" pos="3740.4^74.7" pos_v12="3740.474.7">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="6" name="Match_Type" value="Exact"/>
                <parameter type="8" name="Fuzziness" value="80"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <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="1561" name="Rename_Cols" pos="3979.8^74.7" pos_v12="3979.874.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="Shuffle%20in%20zip-art"/>
            </parameters>
        </transform>
        <transform id="1563" name="Fill" pos="1107^74.7" pos_v12="110774.7">
            <parameters>
                <parameter type="1" name="Columns" value="12"/>
                <parameter type="6" name="Direction" value="Down"/>
            </parameters>
        </transform>
        <transform id="1564" name="Fill" pos="2543.4^-45" pos_v12="2543.4-45">
            <parameters>
                <parameter type="1" name="Columns" value="123"/>
                <parameter type="6" name="Direction" value="Down"/>
            </parameters>
        </transform>
        <transform id="1565" name="Fill" pos="2543.4^194.4" pos_v12="2543.4194.4">
            <parameters>
                <parameter type="1" name="Columns" value="123"/>
                <parameter type="6" name="Direction" value="Down"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="0" end_id="6"/>
        <connection start_id="6" end_id="1520"/>
        <connection start_id="6" end_id="1519"/>
        <connection start_id="1519" end_id="1521"/>
        <connection start_id="1520" end_id="1523"/>
        <connection start_id="1521" end_id="1522"/>
        <connection start_id="1522" end_id="1524"/>
        <connection start_id="1523" end_id="1524"/>
        <connection start_id="1524" end_id="1525"/>
        <connection start_id="1525" end_id="1563"/>
        <connection start_id="1526" end_id="1544"/>
        <connection start_id="1526" end_id="1542"/>
        <connection start_id="1542" end_id="1543"/>
        <connection start_id="1543" end_id="1548"/>
        <connection start_id="1544" end_id="1546"/>
        <connection start_id="1545" end_id="1547"/>
        <connection start_id="1546" end_id="1545"/>
        <connection start_id="1547" end_id="1565"/>
        <connection start_id="1548" end_id="1564"/>
        <connection start_id="1556" end_id="1557"/>
        <connection start_id="1557" end_id="1558"/>
        <connection start_id="1558" end_id="1559"/>
        <connection start_id="1559" end_id="1560"/>
        <connection start_id="1560" end_id="1561"/>
        <connection start_id="1563" end_id="1526"/>
        <connection start_id="1564" end_id="1556"/>
        <connection start_id="1565" end_id="1556"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
