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.