• SKIP IF Duplicate

    From istate2009@21:1/5 to All on Thu Feb 27 17:30:43 2020

    I am trying to pull data from a source that has some duplicate entries (records) and I want to skip any records if a field value already
    appears in the previous records

    Data Source
    AC01 | Red | Blue | Green
    AC01 | Blue | Yellow - Red
    AC02 | Green | Blue | Green
    AC02 | Blue | Red | Green

    In the scenario above I would only want to print one of the AC01 rows
    and one of the AC02 rows. doesn't matter which one. Just want to remove
    the duplicate row based on column 1.

    Not sure if this is even possible.

    Thank you in advance

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)