One Table. Delete dup records where email and last name is same (I got that part in a query), but take info from one field "Invite" from the duplicate records and concatenate in into the first record of the dup and delete the other dups. Note: There can be 2 or more dup records, so I will need all the "Invite" fields from those dups added to another field in the table for the row that will be kept, not deleted, and then go to the next set of dup rows and repeat.
Adam Schwanz
@Reply 10 months ago
Can you elaborate on everything a little bit more? This should be pretty simple with a couple sql statements.
Does it matter which record is the original? Or does it not matter whether we append Record 1 to 2, or 2 to 1 (basically are their related records in other tables to worry about?)
What do you mean concatenate? If ABC was the invite for 1, and XYZ was the invite for 2. Would this need to be a related table with 2 records, one for ABC and one for XYZ? Or is it literally concatenating the strings and the new invite would be ABCXYZ?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
