Remove Duplicate values with a condition
martin.obongita at yahoo.com
Mon Sep 12 17:00:08 UTC 2022
I have played around with this duplicate.
There is this command: $selectduplicates.
Using this command will select the second duplicate row.
Is there a way to set the command to select the first duplicate row?
Kind regards,Martin O.
On Monday, September 12, 2022 at 03:24:37 AM GMT+3, Paul Mulroney <pmulroney at logicaldevelopments.com.au> wrote:
I had to do this recently where I wanted to remove any duplicates the combination of two fields - first name and last name.
This is how I did it (Studio 10.0, but should work anywhere). Note I had to create a local var vsFullName
# Remove duplicates - same first name and surname
Do vlOutput.$sendall($ref.vsFullName.$assign(con($sendallref.FirstName,' ',$sendallref.LastName))) ## Create special column to remove dups
You might need to do something similar.
> On 12 Sep 2022, at 4:52 am, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> Hi ALL,
> I have the method below to remove duplicate rows in a listDo iSQLTableColNameRowList.$sort($ref.lOriginalColName,kFalse)
> Do iSQLTableColNameRowList.$cols.lOriginalColName.$removeduplicates()
> The problem is it deletes all duplicate rows.
> How do I remove duplicate rows in a list with a condition, say, remove all duplicates but check that C7(the column flag in the list) is true?
> Kind regards
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
Is it wrong that only one company makes the game Monopoly?
Paul W. Mulroney We Don't Do Simple Pty Ltd
pmulroney at logicaldevelopments.com.au Trading as Logical Developments
www.logicaldevelopments.com.au ACN 161 009 374
Ph: +61 8 9458 3889 86 Coolgardie Street
BENTLEY WA 6102
More information about the omnisdev-en