Remove Duplicate Records

Good afternoon everyone,   I know that this has a simple solution but for some reason I am struggling with this implementation. I have an entity that has a series of records, each of the records have a unique ID, however I need to run a comparison on a Note field. Although all the records differ I want to remove the records that are the same in the Note field. Can anyone give me the best approach for this?
1 answers

Hi Chet,

Retrieve your records from the database and iterate/loop over them one by one. Use the filter by expression list operation in the loop and make constraint like $iteratorObject/Note = $currentObject/Note and $iteratorObject/id != $currentObject/id.

If found delete the list.

Hope this works out for you.