View Single Post
Old February 27th 20, 05:30 PM
istate2009 istate2009 is offline
Junior Member
First recorded activity by WordBanter: Feb 2020
Posts: 1
Default SKIP IF Duplicate


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