Merging duplicate records

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
JayBell
Posts: 45
Joined: Sun Oct 16, 2011 10:35 am

Merging duplicate records

Post by JayBell »

Hi,

I imported some data for a client and accidentally imported an ID field (Source) instead of the linked value. Result is something like

BOCustomers
ID FName SName Source
1 Fred Bloggs 34
2 Bart Simpson 34
3 Jo Doe 15

There are of cause many other columns of data in the real BOCustomers

After realising my mistake I created another import file of ID and Source hoping this would perform an update on matching records. Sadly it didn't and now I have this:

ID FName SName Source
1 Fred Bloggs 34
2 Bart Simpson 34
3 Jo Doe 15
1 Google
2 Google
3 Newspaper Ad

I wrote a process to find the duplicates and copy the Source to the more complete record:

FIND Customers WHERE COUNT Customers WHERE(Customers.ClientID=ThisCustomers.ClientID)>0

ThatCustomers.Source=ThisCustomer.Source

This does not give any errors but does not work. Am I using "this" and "that" corrrectly? It's difficult to find help on common words like those! I'm wondering if i should be calling a second process?

This is a one off process by the way, it will not be an end user function so if anyone could help with a quick process or query idea then I'd be very grateful.
Post Reply