Looks like several folks have looked at this but no repsonses...Is it confusing?
Your question had an uncanny similarity with a question in another forum; I thought you were somebody else … so to speak.
See if this post helps you; it describes a general approach to compare data sets and identify new and missing customers therein.
1 of 1 people found this helpful
If I understand your requirement correctly, I think you can approach the task by using the fact that following any import, you will always be left with a found set of the imported records in the recipient table. That means you can use Show Omitted to see a found set of the reords that were not uppdated by the import. You can then mark these records as inactive using a Replace command in the appropriate field.
To make this work your ContactImport table should have no records before the import from the CSV file. After cleaning up the data as needed, it would be during the import of these records into your main Contacts table where you'd manage the two found sets for marking the inactive contacts.
There will be other ways of accomplishing your request but the above procedure requires no additional relationships, nor the assembly of record IDs. You need to run through the procedures manually before encapsulating the steps into a script. You also have to be mindful of deleting any fields in the recipient tables as that will surely rearrange your import maps, unless to have matchig field names in the two Contact tables and set that option when creating the import map.
I hope this helps,
Thank you for the insights, this was what I was thinking but you validated my assupmtions. I need to spend time with the scripting but it sounds pretty straight forward.
Thank you Erolst, and you are correct that is very simular to my question...