Topic Options
#56363 - 10/09/18 02:35 PM Handling Duplicate Records
Dean Offline
OL Toddler

Registered: 04/11/13
Posts: 37
Hi

I have a tricky one - removal of duplicate records.

I have a Workflow that determines whether or not to post a letter or send an email, which is conditional on whether or not an email address exists.

However, there are occasions where, if the same email address exists in the data more than once, I would like to send a letter and not several emails.

Any ideas/help would be appreciated thanks.

Top
#56364 - 10/09/18 02:49 PM Re: Handling Duplicate Records [Re: Dean]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 479
Loc: Québec, Canada
I would suggest to pre-process your data and re-arrange (group it) it per email addresses.

But without more information on your data like which type of data (line printer, CSV, XML, etc...) it is kind of hard to steer you in the right direction

Top
#56365 - 10/10/18 04:07 AM Re: Handling Duplicate Records [Re: Dean]
Dean Offline
OL Toddler

Registered: 04/11/13
Posts: 37
Thanks.

It's a csv file if that helps at all?

Was hoping to avoid any pre processing if I could.

Thanks very much
Dean

Top